Thread: Copy values from Sheet1 - Row E1, E2, E3 etc to Sheet2 - Column A1, B1,C1 etc with help of formula
View Single Post
 
Old 10-14-2021, 04:49 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
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