Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to transpose table and create new set of columns

Meteor

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

Highlighted
Magnetar
Magnetar

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. 

Highlighted
Meteor

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


 

Labels