Split column into Rows at null value

[oneillp111]

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.

Wanted Output

[MarqueeCrew · Accepted solution]

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

Now for coffee.

Cheers,

Mark 

[EW · Accepted solution]

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

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

[oneillp111]

 Thank you both for this.  Both solutions worked great