Pivot Table based on fields from a column

[acura123]

I have data structured in a table in that the fields are along the Column axis and the date are along the top row. Can you still do a pivot table in this format or do you need to invert the column and row fields.

Example:
1/1/21 1/15/21
Sales

 

[alansidman]

Can you show us an example with 5-8 records. Please use XL2BB so that we know exactly how your data is arranged and positioned.