Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine multiple rows of data into one row.
Happy New Year!
Could I have some help to find a solution to my task. In column A I have about 3000 rows of data, The string in the first cell starts with the symbol , which then follow with strings in preceeding cells which do not start with the symbol , then again there may be a another string in a cell which does start with the symbol . I need a macro that looks from top to bottom in col A for a string that starts with , then combine that string with other strings below that do not start with , if the string below starts with then it should stop combining. Simply put the symbol denotes the start of a sentence. Any help will save my little fingers goinig numb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine multiple rows into one. | Excel Discussion (Misc queries) | |||
Formula/ Macro to combine data from multiple rows | Excel Programming | |||
How do I combine multiple rows with like data in Excel? | Excel Discussion (Misc queries) | |||
Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
Combine multiple rows to 1 row.... help | Excel Programming |