cancel
Showing results for 
Search instead for 
Did you mean: 

How to transpose table and create new set of columns

SOLVED
Highlighted
Aldona_S
Atom

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

 

ININOUTOUT

BarnesK
Bolide

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
Atom

This is exactly what I needed , thank you @BamesK


BarnesK 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.