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
Solved! Go to Solution.
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
Thank you both for this. Both solutions worked great