ExcelBanter - Complicated Pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Complicated Pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/448534-complicated-pivot-table.html)

Excel Dumbo

Complicated Pivot table

1 Attachment(s)

Hello,

Please see the attachment and please advise on how to build a pivot table from the shown source data without making any changes to the structure of the source data.

Thanks
Dumbo

All times are GMT +1. The time now is 02:37 PM.