Forum Discussion

i_stanescu_ro's avatar
i_stanescu_ro
Icon for Helper I rankHelper I
2 years ago
Solved

How to work with months as column headers

Hi guys   I have this type of a table: category subcategory product colour Jan-22 Feb-22 Mar-22 Apr-22 food beverages coca cola red                      120                      ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi i_stanescu_ro 

     

    You'll need to pivot the month columns into rows so that the data is structured in the proper way for reporting.

     

    Please provide some sample data so I can show you.

     

    regards

     

    Phil

i_stanescu_ro's avatar
i_stanescu_ro
Icon for Helper I rankHelper I
2 years ago

Thanks so much, Phil!

 

I did it! 🙂