combining delete blanks, left shift, insert row with transpose

Hi
How do I go about combining the folowing functions in the attached file

I need table 1 to look like table 2 (or something similiar) obviously a bigger file

so basically delete blanks and shift left (but ideally only within a few columns so not column j for example)

Then insert the required the number of rows transposed in a column.

then repeat for the next line

Hope that makes sense, thanks for any help

Please Login or Register  to view this content.