I have a dataset in Excel where month data is stated in rows along with ticket types, making it difficult to analyze. Here’s a sample of what my data looks like:

Screen shot of my dataset, it can scroll more to the right until DEC

I need to transform this data so that month has its own columns. For example, I want each value to have its own month. Also, if possible, i want for example “NTT Creation” its own column (the same way goes for other ticket types ), and then another column “Month” beside it so i know this ticket type is for which month. The rest of the data seem alright already to me.

How can I achieve this transformation using Power Query or any other method in Excel?

I appreciate any suggestions or guidance on how to do this.

Thank you!

I tried several methods to transform the data:

• Transposing the data: This partially helped but did not achieve the desired structure since the months were still not aligned correctly.
• Pivoting the data: I attempted to use a pivot table, but I struggled to get the months to appear as separate columns.
• Filling in manually: This was very time-consuming and prone to errors.

As a newbie data analyst intern, I am looking for a more efficient and accurate method to transform this data. I am expecting a solution that will restructure my data so each ticket type value has its month.