Hello,
I am looking at a Excel (2013) macro to perform the following tasks:
1. A macro that concatenates the 'Item' values that have the same ID numbers (as shown in Result tab). The ID number cells are merged for the same item numbers as shown in the "data" tab.
2. A macro that splits the cell containing multiple IDs (for item5) so that new lines are created for each ID along with all the other data as shown in Result tab.
These two macros can be two different macros or one single macro performing both tasks.
Please help!
I am looking at a Excel (2013) macro to perform the following tasks:
1. A macro that concatenates the 'Item' values that have the same ID numbers (as shown in Result tab). The ID number cells are merged for the same item numbers as shown in the "data" tab.
2. A macro that splits the cell containing multiple IDs (for item5) so that new lines are created for each ID along with all the other data as shown in Result tab.
These two macros can be two different macros or one single macro performing both tasks.
Please help!