Hi All,
I usually take dump form multiple resources and merge the data to get the required output.
But in the recent past I am getting multiple items in a single cell and the respective row data is same for all.
EX:
Item Code---------Product---Cost -------Area
F1------------------Car--------7,45,000--Region1
F2, F3 -------------Bike------45,000-----Region2
F4------------------Cycle------15,000----Region3
Desired result:
Item Code--------Product----Cost -------Area
F1-----------------Car---------7,45,000--Region1
F2-----------------Bike--------45,000----Region2
F3 ----------------Bike--------45,000----Region2
F4-----------------Cycle-------15,000----Region3
Can some one suggest me how to split F2 & F3 and copy the respective record next to the row.
I have over 5000 records and over 10 items in a single cell.
Thanks,
Lalit Kanth Vutpala