How to work with months as column headers

[i_stanescu_ro]

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	258	25	456

I have no idea how to work with this type of table in Table View for, let's say, creating a table or a graph with the number of beverages sold every month.

I have never worked with columns as months, just lines...

Can you guys help out here?

Thanks so much!

[i_stanescu_ro]

Thanks so much, Phil!

I did it! 🙂

[PhilipTreacy · Accepted solution]

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