How to transpose table and create new set of columns

[Aldona_S]

Hello

I have an excel file in format shown in the first table (IN) that I would like to arrange in a way that is demonstrated in the second table. Does anyone have a ready workflow on how to go about this? Many thanks in advance for your help

INOUT

[Kenda · Accepted solution]

Hey @Aldona_S! See if the attached workflow is what you need. The key was to Cross Tab first then split the data into multiple columns. 

[Aldona_S]

@This is exactly what I needed , thank you @BamesK

---

@Kenda wrote:

Hey @Aldona_S! See if the attached workflow is what you need. The key was to Cross Tab first then split the data into multiple columns. 

---