Forum Discussion
TRANSFORM MULTPLE COLUMNS INTO LESS COLUMNS, MORE ROWS
I am working with a ghastly excel spreadsheet which holds daily totals in multiple columns. I have manipulated the table in Power Query to simplify the data into three sets - Date, Attribute and Tot...
Anonymous , rename the column with suffixes like 1 ,2 etc
Create the first row as a header
unpivot all rows
split the attribute on space (if you have created date 1, attribute 1)
then pivot the attribute.1 and value column
amitchandak
Super User
Super UserAnonymous , rename the column with suffixes like 1 ,2 etc
Create the first row as a header
unpivot all rows
split the attribute on space (if you have created date 1, attribute 1)
then pivot the attribute.1 and value column