Split column into Rows at null value

Question

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 Answer

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

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.