Dear all,




I'm trying to turn a "cross-table" into a flat list, but even after i lot of searching and reading i haven't yet achieved what i want.


First i'll give some context:


Let say table A is a cross-table, with columns which describe a cabinets' width, and with rows describing the cabinets' type. (In this example low, medium and high cabinets)


Now, in this table each customer fills in the desired number he wants to buy.


These data should be converted to a flat list, so further in the excel sheet, a list can be made (let's say as a quotation) in which the different combinations can be given a price (automatically)


Now, i will upload a picture of the file i'm using as example.


I hope you can help me turning the pivot table into a list (Dynamically)


Preferably without VBA (should be dummyproof when finished), but if really necesarry, it ain't a problem.

I attached the sample as shown in the picture above



Thanks in advance,


Arno

Attached Files

Cross-Table.xlsx (13.8 KB, 13 views)