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

piyushj's avatar
piyushj
Frequent Visitor
9 years ago
You can also use new tabular table custom visual.
Related content