PIVOT Table Help

[ChetanPuri]

Hi Excel Gurus's

Just a question regarding Pivot Table, I want to have Dates as a Header and the Data on Rows below it but unfortunately, when I add the date to show on the column, it shows the data as the header. Please see attached image, any help will be appreciated.

Many thanks,
Regards,
Chetan

 

[Alex Blakenburg]

Your months are columns in your original data set. Therefore you need add the month headings into the Value box (not the Columns box).