I have to process a data set which has the following format:
My target is to bring it in the following format:
Waiting for ##### team ABxxxxxxxxxxx ABCDE4FG25HI7J5K Waiting for ##### team ABxxxxxxxxxxx LMN123OPQ45RST Waiting for ##### team ABxxxxxxxxxxx UV12398765WXYZ Waiting for $$$$ team AByyyyyyyyyyy 95597836355278 Waiting for $$$$ team AByyyyyyyyyyy 9666382677292 Waiting for @@@@ team ABzzzzzzzzzzz MBAWAXZSE1234TU
With values separated by comma to be entered in the row below it.
Can someone please suggest me a vba code to accomplish the above task?
Detailed explanation of problem:
1. I have a very huge data set with 10,000+ rows and 28 or more columns.
2. My data has 2 IDs, one is identification number and 2nd is multiple sub-identifications under it separated by commas.
3. Each sub-identification under the identification number has one issue associated with it.
4. So my task was to bifurcate sub-identification numbers separated by comma into multiple lines and use a combo of Identification number and Sub-identification number as a Unique ID to map the resolution status of all issues associated with an identification number.
The same question has been asked at: