Forum Discussion

generaluser's avatar
generaluser
Regular Visitor
9 years ago
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...
  • Sean's avatar
    Sean
    9 years ago

    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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi generaluser,

 

Have you tried the solution provided above? It should work in your scenario. If you still have any question on this issue, feel free to post here.

 

In addition, if the solution works, could you accept it as solution to close this thread? :smileyhappy:

 

Regards

Related content