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 :))

binu_acs
21 - Polaris
Labels
Top Solution Authors