Forum Discussion
Solved
Converting multiple columns into 1 column
Hi, I would like to group multiple columns into one column. I have the product name in column A, and then the units by month in the columns after. I would like to keep column A as the product nam...
In the Query Editor
1) select the Product Column
2) Transform tab - Unpivot Columns - Unpivot Other Columns
3) Rename the Attribute and Values columns - Month and Units
In the Query Editor
1) select the Product Column
2) Transform tab - Unpivot Columns - Unpivot Other Columns
3) Rename the Attribute and Values columns - Month and Units
Such a useful function! :)
Hi Sean, I have a table with 126 columns, that I need to be able to split out 60 columns and have them then line up based on the GUID. They are the details that are attributed to each IR # that is entered based on a date and station ID.
