ExcelBanter - Slightly long winded transposition

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Slightly long winded transposition (https://www.excelbanter.com/excel-programming/350394-slightly-long-winded-transposition.html)

Slightly long winded transposition

4073 Leary Rob U5 U51EN/SMT EN
4073Leary Rob U5 U5CCH1 CH AEW
4073 Leary Rob U5 U5AAR1 AR LC
4073 Leary Rob U5 U5BHI1 HI RF
4073 Leary Rob U5 U5EPE1 PE SMX
4073 Leary Rob U5 U5FIT3 IT AH
4073 Leary Rob U5 U5DFR2 FR CEL
4073 Leary Rob U5 U5MA/PJW MA PJW

Slightly long winded transposition

Sorry my pc went a bit loopy and posted before I had finished writing.

I need a routine that systematically takes the last three columns (starting
at the second row) and moves the data up to the first row, basically I will
get 25 columns and 1 row when I finish.

"Wendy" wrote:

4073 Leary Rob U5 U51EN/SMT EN
4073 Leary Rob U5 U5CCH1 CH AEW
4073 Leary Rob U5 U5AAR1 AR LC
4073 Leary Rob U5 U5BHI1 HI RF
4073 Leary Rob U5 U5EPE1 PE SMX
4073 Leary Rob U5 U5FIT3 IT AH
4073 Leary Rob U5 U5DFR2 FR CEL
4073 Leary Rob U5 U5MA/PJW MA PJW

Thanks for help

Wendy