|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
10-13-2021, 09:09 PM
|
|||
|
|||
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
10-13-2021, 10:10 PM
|
|||
|
|||
|
Like this?
|
|
#3
10-14-2021, 04:49 AM
|
||||
|
||||
|
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
12-14-2021, 04:53 PM
|
|||
|
|||
|
Thanks a lot!!
|
|
#5
12-14-2021, 04:54 PM
|
|||
|
|||
|
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 |
Windows 10 
Office 2019
Linear Mode
