|
|
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
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
|
||||
|
||||
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. |
#4
|
|||
|
|||
Thanks a lot!!
|
#5
|
|||
|
|||
Thanks a lot ! !
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Try to Copy cells from Sheet1 to Sheet2 | mikehk | Excel | 3 | 09-22-2017 03:27 AM |
Moves multiple rows from Sheet1 to Sheet2 | khawajaanwar | Excel Programming | 2 | 09-09-2016 11:21 AM |
How to update Sheet1 from Sheet2 automatically? | 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 |
How to merge two cells from sheet1 to one cell in sheet2 in next sheet | KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |