Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Split column into Rows at null value

oneillp111
9 - Comet

I have a column of data as seen in the image below.  I am trying to figure out a way to split the data into columns once it hits a null value.  Outputting 3 columns.  Any ideas? I tried with cross tab but i don't think that is right for this.

Example.png

Wanted Output

 

2020-08-21_11h39_50.png

 

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@oneillp111 ,

 

I used several multi-row formulas to determine which transaction sets belonged together and which rows they were within the set.  First I started with the transaction type and built out data that could be cross tabbed together.

 

capture.png

 

Now for coffee.

 

Cheers,

 

Mark 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
EW
11 - Bolide

On way to do this would be a couple of multiple row formulas and Cross Tab, like this:

rows.PNG

Numbering the rows to reset after nulls, and making the new headers their own column.

oneillp111
9 - Comet

 Thank you both for this.  Both solutions worked great

Labels
Top Solution Authors