| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging multiple cells into a single cell
Dear all,
please help me, i have a two column data. I need to merge data from column b with the same data in column a into a single cell separated by ";". the sheet looks as follows: ---A--- ---B--- Job ID Name 335119 Malonzo, Elaine 335119 Monsalve, Edmund 335119 Pilapil, Flofer 335119 Pilapil, Flofer 335119 Santiago, Minerva 335212 Calub, Charina 335212 Calub, Charina 335212 Calub, Charina 335212 Requita, Darius 335212 Santiago, Minerva 335253 Bonifacio, DaisyLou 335253 Bonifacio, DaisyLou 335253 Delos Santos, Veronica 335253 Delos Santos, Veronica 335253 Llamas-Ong, Christine 335253 Llamas-Ong, Christine 335253 Reyes, Wilson I need it to look like this.... ---A--- ---B------------------------------------ Job ID Name 335119 Malonzo, Elaine; Monsalve, Edmund; Pilapil, Flofer; Santiago, Minerva 335212 Calub, Charina; Requita, Darius; Santiago, Minerva 335253 Bonifacio, DaisyLou; Delos Santos, Veronica; Llamas-Ong, Christine Hoping to have an answer. best regards, akaDong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging multiple (n) cells into one cell | Excel Discussion (Misc queries) | |||
| Concatenate Multiple Cells into A Single Cell | Excel Discussion (Misc queries) | |||
| Merging multiple workbooks with crosslinked formulas into single f | Excel Discussion (Misc queries) | |||
| How to Copy single Cell into Multiple cells | Excel Worksheet Functions | |||
| Using a single cell value to repopulate multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
