Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Pivot

Copper Contributor

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 

 

glodwajz_1-1701289452301.png

 

 

1 Reply
best response confirmed by glodwajz (Copper Contributor)
Solution

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

1 best response

Accepted Solutions
best response confirmed by glodwajz (Copper Contributor)
Solution

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

View solution in original post