Transpose from Vertical to Horizontal

[Legacy 185509]

Hello
I have data in column B does like this

B
1
2
3
4
5
6
7
8
9


I want to transpose this data in sheet2 start from B1 I want to tranpose with empty column in between for calculation

B____C_____D______E_____F______G______H___
1__________2____________3_____________4___
Please Help
Thank you

 

[ADAMC]

Think this is what you might require:

http://www.mrexcel.com/forum/showthread.php?t=307157

change column references to suit.

HTH