Forum Discussion

vips's avatar
vips
Frequent Visitor
6 years ago
Solved

Transforming values in a single column to column header

I have the following data   Product ID Year Shipped Month Shipped $   Month has values: Jan, Feb, Mar ... Nov, Dec    Need to transform this to: Product ID Year Shipped Jan Feb ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi vips ,

     

    I'm not sure whether you need to change your data model or show your data like that?

     

    If you don't need to change your data model, you can use Matrix to make it like the below screenshot.

     

    Aiolos Zhao

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi vips ,

 

I'm not sure whether you need to change your data model or show your data like that?

 

If you don't need to change your data model, you can use Matrix to make it like the below screenshot.

 

Aiolos Zhao

 

  • vips's avatar
    vips
    Frequent Visitor
    6 years ago

    This worked great!! Thanks!