convert data table to list for pivot table building

[masben]

Hi

Do anyone now of a macro to covert a excel table into a list so that you from that can build a pivot table?

I have a forecast file with several thousands of rows. In the colum heading I have things like product, customer, type, depot etc. + quantity for 12 months please see the attached file. I like to convert this table into a list to build pivot tables from. I think a macro could do the trick.

thanks,
Martin