Forum Discussion
Stack Multiple Columns
I have a terrible spreadsheet I can't change the format of . . . . It's multiple serial numbers across 4 different columns with their individual statuses. How can I stack all these columns into...
You can make 4 versions(copies) of the table.
Remove the appropriate columns so that each version has s/n and status for a pair of columns (1, or 2 or 4 or 8).
Rename the columns in each version to s/n and status. (they must be the same in each version)
Append the tables.
You can make 4 versions(copies) of the table.
Remove the appropriate columns so that each version has s/n and status for a pair of columns (1, or 2 or 4 or 8).
Rename the columns in each version to s/n and status. (they must be the same in each version)
Append the tables.
This makes a lot of sense; I didn't think logically about it - I can also teach this to someone who doesn't know Power Query.