Restructuring Report

Question

Hello SME,

I'm trying to change the layout of the Data tab into the Report tab without using the Report tool.  What's the best approach to do this?  I suppose that I could do it the long way but I'm trying to figure out the best approach.

Thank you,

kwl

Output Example.xlsx

Qiu · Accepted Answer

@knnwndlm 
If I understand your intention correctly, it is a typical use of "Cross Tab".

Qiu · Accepted Answer

@knnwndlm 
We can use a Tile tool to get the original order and bring into the result as below.