Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Make value in a column into columns

Hello this is what my current data looks like: - I need the company name to be in the column - Please help  COMPANY Number  COMPANY Name  Account Description  Type A  Sort  Type B  FY18   ...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • ERD's avatar
    ERD
    5 years ago

    Hi Anonymous ,

    1. Choose columns with values (FY18 - FY20), click Transform - Unpivot columns (you will get 2 columns: Attribute & Value).

    2. Choose Company_name and Attribute columns, click Transform - Merge Columns, choose Space as a Separator (you will now see 2 columns: Merged & Value).

    3. Choose Merged and Value columns, click Transform - Pivot Column. Values column - Value, Aggregate Value Function - Don't aggregate (Advanced options).

     

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

ERD's avatar
ERD
Community Champion
5 years ago

Hi Anonymous ,

1. Choose columns with values (FY18 - FY20), click Transform - Unpivot columns (you will get 2 columns: Attribute & Value).

2. Choose Company_name and Attribute columns, click Transform - Merge Columns, choose Space as a Separator (you will now see 2 columns: Merged & Value).

3. Choose Merged and Value columns, click Transform - Pivot Column. Values column - Value, Aggregate Value Function - Don't aggregate (Advanced options).

 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much ERD this save me so much headache. 🤗