Show column value as date

[Hamdan1234]

I have this data and each month has been shown as column but I want to show sparkline for total number of months which is not possible because it is not in a single colum. I have to show each keyword and its searches in sparkline. I also need to show the percentage of final score. for each keyword. I have also transposed the data but it has transposed it al the way then I am facing problem regarding my column of Final score. What should I do now. Please help.

[HotChilli · Accepted solution]

Looks like you want to unpivot those date columns in Power Query.

You might relate the new column to a calendar table which contains a month number so that you can use it to sort the dates correctly.  There's plenty of examples around on how to do this.