| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i align rows of data
I have two large sets of data on the same worksheet. One is complete (A1,
A2,A3 etc) and the other has irregular ommisions (A1,A5,A7 etc). How do I sort the data so that A123 from the first set is in the same row as A123 from the 2nd set? I need to be able to transpose data from the 2nd set onto the 1st whilst maintaining it's relationship to the refference numbers (A1, A2 etc). I am using excel 2002. I'm sure that this is a simple question but I can't figure it out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Controlling odd even rows when pasting data | Excel Discussion (Misc queries) | |||
Threaded Mode
