Converting data in one column spanning three to four rows
Closed
rhinoramanan
Posts
1
Registration date
Friday July 21, 2017
Status
Member
Last seen
July 21, 2017
-
Updated on Jul 21, 2017 at 04:30 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Jul 21, 2017 at 06:06 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Jul 21, 2017 at 06:06 PM
Related:
- Converting data in one column spanning three to four rows
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to delete column in word - Guide
- Data transmission cable - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Jul 21, 2017 at 05:33 PM
Jul 21, 2017 at 05:33 PM
Hi.
Try this ...
Select the range of data you want to rearrange.
Press Ctrl and X at the same time (the cells disapear).
Right-click the first cell where you want to paste the data.
Choose "Transpose" under the Paste Heading (the data reapears in the way you want it).
Save your Worksheet.
I hope this helps.
Try this ...
Select the range of data you want to rearrange.
Press Ctrl and X at the same time (the cells disapear).
Right-click the first cell where you want to paste the data.
Choose "Transpose" under the Paste Heading (the data reapears in the way you want it).
Save your Worksheet.
I hope this helps.
Jul 21, 2017 at 05:42 PM
Jul 21, 2017 at 05:49 PM
Jul 21, 2017 at 05:58 PM
Good luck and be brave. I will send you some oranges.
God save the Queen !
Jul 21, 2017 at 06:06 PM