Restructuring Report

[knnwndlm]

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

[Qiu · Accepted solution]

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

[knnwndlm]

Thank you!  That's what I got wrong in one of the fields.  That's why I couldn't get it to work.

[knnwndlm]

@Qiu 

How do I keep the original order in the final result?

[Qiu · Accepted solution]

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