Pivot

[glodwajz]

Hi, I'm learning Pivot Tables and I have the following problem. I need to split the orders table into individual items. To be in the same format as in the green table. Can you help with this??? Thank you in advanced 

[#2 · Accepted solution]

@glodwajz You cannot do that in a pivot table - it always groups identical items together.