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.
NewStep=#table({"S/N","Status"},List.TransformMany(List.Split(Table.ToColumns(PreviousStepName),2),List.Zip,(x,y)=>y))