| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Join multiple rows data into one row
I have similar issue but more complecated. Here is an example of wha I am tying to do: A1 = 123b A2 = asf A3 = afasf A4 = afasf A5 = awry A6 = net A7 = A8 = tegndg A9 = dgndg A10 = dgndg A11 = sd A12 = sdb A13 = fbsf A14 = sffsbsf A15 = A16 = sfbsf A17 = sfbsf A18 = bwr A19 = sfbsf A20 = sfbsf A21 = A22 = sfbsf A23 = sfbsfb A24 = sfbf A25 = sfb A26 = sfb A27 = sf A28 = I need all text in one row for text located between an empty cells, so A1 to A6 will combined, A8 to A14 will combined, A16 to A20 will combined, preferably in anew sheet. Thanks, Albert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
| Join multiple rows into columns | Excel Discussion (Misc queries) | |||
| Join multiple rows into columns | Excel Discussion (Misc queries) | |||
| conditionally join rows | Excel Discussion (Misc queries) | |||
| join rows? | New Users to Excel | |||
Threaded Mode
