Forum Discussion

GabrielDC's avatar
GabrielDC
Frequent Visitor
3 years ago
Solved

How do I transform this table?

HI All Sorry if this is a rookie question. I have this table [above] with severals months and their items. I'd like to put all the months together in one single column [like the table below].   H...
Need Help
  • GabrielDC's avatar
    GabrielDC
    3 years ago

    Thanks Greg, your answer inspired me to try something:

     

    1) convert all fields to text type

    2) concatenate each month with their respective item

     

    3) Unpivot by these concatenated columns

    4) delete the month/items columns

    5) Split the concatenated column

    6) Profit 🙂

     

    Thanks Greg, we did this!

     

     

GabrielDC's avatar
GabrielDC
Frequent Visitor
3 years ago

Thanks Greg, your answer inspired me to try something:

 

1) convert all fields to text type

2) concatenate each month with their respective item

 

3) Unpivot by these concatenated columns

4) delete the month/items columns

5) Split the concatenated column

6) Profit 🙂

 

Thanks Greg, we did this!