The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.

Start Free Trial

Alteryx Designer Desktop Discussions

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

How to reorient this?

ShantanuDagar
8 - Asteroid

I have a table or a matching sheet which goes like:

 

A   Alt_A

B   XYZ

C   MFD

D    RMP

and so on

 

I need an output in the form of:

 

A  Alt_A  B XYZ  C  MFD  D   RMP

 

Each 1 is in different and continuous column.

 

Around 90 rows like this which should all come in 1 row and in the pattern as specified above

1 REPLY 1
FinnCharlton
13 - Pulsar

Hi @ShantanuDagar , here's a way:

 

image.png

Labels