Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-Arranging a Block of Data
Was wondering if there is a simple way to re-arrange data with some VB code.
I have much more data than in the following example. So this could actually save several hours of work. Thanks in advance, Mark Have data in this format: BOB DAVE JIM HAROLD 1 33 31 15 19 23 22 99 I need it in this format: BOB 1 19 DAVE 33 23 JIM 31 22 HAROLD 15 99 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arranging a data in required format | Excel Discussion (Misc queries) | |||
re-arranging the data | Excel Discussion (Misc queries) | |||
Help Arranging Data on Spreadsheet | Excel Discussion (Misc queries) | |||
Arranging Excel Data | Excel Discussion (Misc queries) | |||
ARRANGING DATA IN PIVOT TABLES | Excel Worksheet Functions |