Dynamic Processing

[bh1789]

Any help would be greatly appreciated on how to remove nulls from columns without removing data on same row as nulls.  So this would be the output to Excel:

Thank you

[nagakavyasri]

@bh1789 Transpose and cross tab the data

[bh1789]

thank you and I had tried the solution you provided me but I have multiple lines and this solution only outputs the first line.  There are 33 lines of data for 1st, 23 lines of data for 2nd group and 2 lines of data for 3rd group

thank you