With the sample file attached, there are 2 columns. Column A has ID that is unique. Column B has comma separate values.
Wherever there are multiple values in columnB, ID in columnA has to be replicated to take values from columnB and create multiple rows accordingly.
Sample file attached. Thanks in advance.
Wherever there are multiple values in columnB, ID in columnA has to be replicated to take values from columnB and create multiple rows accordingly.
ID | Names | ID | Names | ||
123 |
| 123 | Pencil | ||
123 | Paper | ||||
123 | Blue Pen | ||||
123 | Box | ||||
Sample file attached. Thanks in advance.