Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reorganising data
Hi,
I'd like to reorganise data from a spreadsheet as follows: I have a number of columns with a couple of rows as title and some data underneath each. The data is unique in any one sheet. I'd like to copy the information on a new sheet in a different manner. For example A B C ... title1 title2 title3 ... X Y Z xx yy zz xy yx zx xz yz zy I'm looking to have the information reorganised A B C xx title1 X xy title1 X xz title1 X yy title2 Y yz title2 Y .... I will then sort on col A, etc I am new to the VB semantics and look forward to any pointers. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reorganising Data | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |