Trying to pivot with Dates across

[JeffDaMan]

Guys, here's my issue....

I have this data grid that I need to pivot it. Simple.

The problem is that the dates comes across (toward the right) of my main columns.
Usually, I'd rearrange my data in a vertical rather horizontal direction BUT It cannot be moved as per client's request. Well, also because the client needs a Timeline slicer on top of the graphics.

I've been told that a PowerPivot or a PivotQuery reshaping could do it but it's beyond my knowledge.

So, how can I? How would you do it?

Thank you

 

[alansidman]

1. We cannot manipulate data in a picture. Please reload your data using XL2BB so we don't have to recreate your schedule.
2. To make sure we are not guessing at what you want, please mock up your solution so we can see what you need exactly as your explanation is not clear to me.

 

[JeffDaMan]

1. We cannot manipulate data in a picture. Please reload your data using XL2BB so we don't have to recreate your schedule.
2. To make sure we are not guessing at what you want, please mock up your solution so we can see what you need exactly as your explanation is not clear to me.

You're absolutely right!

I couldn't install XL2BB as I have no admin rights in this computer. However I have written the data as I have it in the File.
As you can see here, the Columns with Data comes across my categories (first 2 columns), but I need to pivot it (like the picture) so it can be manipulated as vertical data.

Make	Style	Oct - 3	Oct - 10	Oct - 17	Oct - 24
Toyota	SUV	0	13	5	9
Chevrolet	Sedan	6	2	4	4
Audi	Sport	5	9	6	8
BMW	SUV	2	3	5	4
Subaru	Sedan	8	10	1	5
Honda	Sport	5	4	7	11

 

[alansidman]

You did not supply us with your expected results so I am only guessing. Is this what you want your data to look like?

Make	Style	Attribute	Value
Toyota	SUV	3-Oct	0
Toyota	SUV	10-Oct	13
Toyota	SUV	17-Oct	5
Toyota	SUV	24-Oct	9
Chevrolet	Sedan	3-Oct	6
Chevrolet	Sedan	10-Oct	2
Chevrolet	Sedan	17-Oct	4
Chevrolet	Sedan	24-Oct	4
Audi	Sport	3-Oct	5
Audi	Sport	10-Oct	9
Audi	Sport	17-Oct	6
Audi	Sport	24-Oct	8
BMW	SUV	3-Oct	2
BMW	SUV	10-Oct	3
BMW	SUV	17-Oct	5
BMW	SUV	24-Oct	4
Subaru	Sedan	3-Oct	8
Subaru	Sedan	10-Oct	10
Subaru	Sedan	17-Oct	1
Subaru	Sedan	24-Oct	5
Honda	Sport	3-Oct	5
Honda	Sport	10-Oct	4
Honda	Sport	17-Oct	7
Honda	Sport	24-Oct	11

If so, then unpivot the data with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Make", "Style"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

 

[JeffDaMan]

You did not supply us with your expected results so I am only guessing. Is this what you want your data to look like?


If so, then unpivot the data with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Make", "Style"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

Thank you Alan!
I thought I uploaded a Picture.
But yes, that's exactly what I need my data to look like.
I'm trying it RN.

 

[JeffDaMan]

This worked perfectly!
Thank you so much.

 

[alansidman]

Thanks for the feedback. You are welcome.