![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
![]()
Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula. Currently i have to switch between sheet and copy the column and paste it in Transpose.
|
#2
|
|||
|
|||
![]()
Like this?
|
#3
|
|||
|
|||
![]()
Thanks a lot!!
![]() |
#4
|
||||
|
||||
![]()
If you're using an up to date version of Excel, in cell A1:
=TRANSPOSE(Sheet1!E1:E10) In older versions, same formula, but select cells A1:AJ1 before entering the formula but array-enter it using Ctrl+Shift+Enter rather than the usual plain Enter. |
#5
|
|||
|
|||
![]()
Thanks a lot ! !
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Try to Copy cells from Sheet1 to Sheet2 | mikehk | Excel | 3 | 09-22-2017 03:27 AM |
![]() |
khawajaanwar | Excel Programming | 2 | 09-09-2016 11:21 AM |
![]() |
Xyz_999 | Excel | 4 | 09-06-2016 01:53 AM |
Transferring info from 1column on sheet2 to sheet1 | rogcar75 | Excel | 22 | 08-26-2014 05:07 PM |
![]() |
KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |