We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Changing data from long to wide format

overhead_press
8 - Asteroid

Below I have a table I would like to transform into my second table. The idea is that the row with numbers in col 2 and col 3 is the main row and the rows below that row with null values in col 2 and col 3 belong to that same group. So in my example there are three groups, the rows below the groups I would like to have them as column values, note the column names does not matter. How can I achieve my desired results? Thanks in advance! 

 

Original table:

Col 1Col 2Col 3
MISC PAYMENT 56756789
Org[Null][Null]
CREDIT 12312345
XO[Null][Null]
AX[Null][Null]
CREDIT780123456
ABC[Null][Null]
MC[Null][Null]

 

Desired results: 

Col 1Col 2Col 3Col 4Col 5
MISC PAYMENT56756789Org 
CREDIT 12312345XOAX
CREDIT780123456ABCMC
2 REPLIES 2
JarekSkudrzyk
11 - Bolide

@overhead_press not the prettiest workflow but it gets the job done (I think :))

binuacs
21 - Polaris
Labels
Top Solution Authors