Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for merging rows
I have a fairly large spreadsheet that are sorted based on a file # (ie:
E0800100, E0800101). The spreadsheet is setup to where each entry is on an individual row as seen below: A B C E0800100 Review.... 1.0 (hr) E0800100 Review.... 2.0 E0800101 Review.... 1.5 E0800102 Review.... .5 I am trying to organize the spreadsheet so that there is only one row per file number and the Descriptions (B) and Time (C) extend along the columns of that row. A. B. C. D. E. E0800100 Review.... 1.0 Review..... 2.0 E0900101 Review.... 1.5 E0900102 Review... .5 The spreadsheet is not consistent in that there are 2 or 3 entries for every file number but ranges from 1-15 entries. I attempted to combine various macro formulas I've seen but have had no such luck and am at a loss to if this is possible. Any information or direction to getting this as close as possible would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Rows | Excel Programming | |||
Merging rows | Excel Programming | |||
Is merging rows possible? | Excel Worksheet Functions | |||
Merging rows | New Users to Excel | |||
Merging Two Rows Into One | Excel Worksheet Functions |