Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2021, 09:09 PM
OriginFarms OriginFarms is offline Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Windows 10 Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Office 2019
Novice
Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula
 
Join Date: Oct 2021
Posts: 1
OriginFarms is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-13-2021, 10:10 PM
ArviLaanemets ArviLaanemets is offline Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Windows 8 Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Office 2016
Expert
 
Join Date: May 2017
Posts: 654
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

Like this?
Attached Files
File Type: xlsx Transpose.xlsx (10.7 KB, 2 views)
Reply With Quote
  #3  
Old 10-14-2021, 04:49 AM
p45cal p45cal is offline Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Windows 10 Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Office 2019
Expert
 
Join Date: Apr 2014
Posts: 528
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula Moves multiple rows from Sheet1 to Sheet2 khawajaanwar Excel Programming 2 09-09-2016 11:21 AM
Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula 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
Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft