Forum Discussion
Stacking multiple columns into single column in a table
Hello Anonymous ,
Assuming you have no problem using power query,
Make duplicate of say original table 1 as table 2.
Remove column value 3 and value4 from table1. Rename value 3 and 4 in table 2 as value 1 and value 2.
Then append table 2 in table 1 and you are done.
I can post an example file if it is acceptable but you would like to see an example.
Hello Anonymous ,
Assuming you have no problem using power query,
Make duplicate of say original table 1 as table 2.
Remove column value 3 and value4 from table1. Rename value 3 and 4 in table 2 as value 1 and value 2.
Then append table 2 in table 1 and you are done.
I can post an example file if it is acceptable but you would like to see an example.
Before rename value 3 and value 4 in table 2, remove value 1 and value 2 column.
So if I had values 5-8 that I wanted to append to 1&2 would I just have to create a lot of copies where everything is named value 1 & 2 and append them all?