Cross-table into flat list

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.




Thanks in advance,


Arno
\1

Hello, I do not know if that's it, but this can be achieved easily using the addition of Power Query.
Add another value and refresh the result set.

Hmm, i'm afraid i don't have this option yet. Also, the solution should be easy to use on every pc, because this file will be used in multiple companies where i don't have the possibility to edit the available pc's or excel configurations..

Maybe i'm wrong in this, if so, please correct me

Arno

Hello,

Thank you for the information.

The same file used in the pictures will be attached as a Excel file.

Thanks in advance,
Arno