sheetspread
Well-known Member
- Joined
- Sep 19, 2005
- Messages
- 5,160
Say I have three groups of 10 numbers in a column:
731
1851
397
157
760
457
207
1238
1671
672
1208
1307
1720
877
255
1769
1614
1276
236
304
799
184
1791
1118
1111
757
1328
1072
1572
257
And I want to copy and transpose them into 3 rows at once without copying/pasting each column special:
731 1851 397 157 760 457 207 1238 1671 672
1208 1307 1720 877 255 1769 1614 1276 236 304
799 184 1791 1118 1111 757 1328 1072 1572 257
Can this be done?
731
1851
397
157
760
457
207
1238
1671
672
1208
1307
1720
877
255
1769
1614
1276
236
304
799
184
1791
1118
1111
757
1328
1072
1572
257
And I want to copy and transpose them into 3 rows at once without copying/pasting each column special:
731 1851 397 157 760 457 207 1238 1671 672
1208 1307 1720 877 255 1769 1614 1276 236 304
799 184 1791 1118 1111 757 1328 1072 1572 257
Can this be done?