I was thinking of something like this unpivot_pivot.knwf (35.2 KB)
First do an unpivot of the data, and then change the columns names so you can use them to pivot the data again with only the 3 columns.
Hello HansS Thanks for welcome and solution.
About a cell splitter you used, if I don’t have a character to use as delimiter, would there be other way to do this? Like, Aup Amiddle Abottom etc.
Edit: Oh, never mind! I replaced it with replacer. I should learn more about regex to be efficient tho. Thank you!