"Pull up" columns to clear empty space below titles

[shmee150]

Hi,

I have a spreadsheet as attached where there are titles in row 3, but I want to go along each row and pull up all the data below to the immediate row below the title. This is different in each column but you will see what I mean. I do want this to be VBA and the real spreadsheet has many columns so it needs to cycle along I guess until Row 3 is empty?

Many many thanks in advance,

Tim

[StephenR]

Like this?

Please Login or Register  to view this content.

it needs to cycle along I guess until Row 3 is empty

Not sure I follow this.

[shmee150]

Like this?

Please Login or Register  to view this content.

Not sure I follow this.

Yepo did the job perfectly, so I guess no worries by my bad English there! Thank you ever so much.

Tim