Horizontal to Vertical

[kilosub]

Hi All,


I need help to move data in row from a1 to au1 (Horizontal) to a new sheet, can be anyway but in vertical format.


Thanks in advance.


Cheers!!

Kilosub

 

[syntaxed]

If this is just a one-time transfer, then Paste Special Transpose might be the best solution

 

[syntaxed]

Otherwise use the TRANSPOSE() function.

Example:
1. In Sheet2, select A1:A47
2. In the Formula Bar, type =TRANSPOSE(Sheet1!A1:AU1)
3. Enter the formula as an array, i.e. by pressing Ctrl+Shift+Enter

 

[kilosub]

Hi Syntaxed,

Thanks, solve using both method..

Thanks a lot.


Cheers!!

Kilosub

 

[Peter_SSs]

Just is case you want a 3rd way you can use INDEX with this sort of formula (copied down).

Excel Workbook
	A	B	C	D	E	F
1	a	b	c	d	e	f
2
3	a
4	b
5	c
6	d
7	e
8	f
Transpose

 

[kilosub]

Awesome!! Thanks a lot, Peter!! I'll take note on this too..