Welcome to the MrExcel board!

Is this, copied to the right what you are looking for?

Transpose

A B C D E 1 Mike Suzy Ken Ann 2 Mike xx abc 3 Suzy xx 4 Ken 5 Ann abc

Spreadsheet Formulas

Cell Formula C2 =INDEX($B2:$B5,COLUMNS($B2:C2))&""

Excel tables to the web >> Excel Jeanie HTML 4

## Like this thread? Share it with others