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: 4
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: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Like this?
Attached Files
File Type: xlsx Transpose.xlsx (10.7 KB, 9 views)
Reply With Quote
  #3  
Old 12-14-2021, 04:53 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: 4
OriginFarms is on a distinguished road
Default

Thanks a lot!!
Reply With Quote
  #4  
Old 10-14-2021, 04:49 AM
p45cal's Avatar
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: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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
  #5  
Old 12-14-2021, 04:54 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: 4
OriginFarms is on a distinguished road
Default

Thanks a lot ! !
Reply With Quote
Reply



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 07:14 AM.


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