Converting data in one column spanning three to four rows
Closed
rhinoramanan
Posts
1
Registration date
Friday 21 July 2017
Status
Member
Last seen
21 July 2017
-
21 Jul 2017 à 14:30
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Moderator Last seen 30 September 2021 - 21 Jul 2017 à 18:06
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Moderator Last seen 30 September 2021 - 21 Jul 2017 à 18:06
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 17 January 2015
Status
Moderator
Last seen
30 September 2021
149
21 Jul 2017 à 17:33
21 Jul 2017 à 17:33
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.
21 Jul 2017 à 17:42
21 Jul 2017 à 17:49
21 Jul 2017 à 17:58
Good luck and be brave. I will send you some oranges.
God save the Queen !
21 Jul 2017 à 18:06