Hello,
I have a cell that contains various number of text separated by commas. I would like for the information separated by commas to go into a list below the first item in the cell. Here is an example.
Current Data
<tbody>
</tbody>
This what I want it to look like.
<tbody>
</tbody>
I am not well versed on the use of Macros. So if you can explain it like I am 5 that would be great. I truly appreciate your help as I have over 5,000 rows of data.
I have a cell that contains various number of text separated by commas. I would like for the information separated by commas to go into a list below the first item in the cell. Here is an example.
Current Data
ID Number | First Name | Last Name | Involvement |
58475 | Kate | Smith | Law Review,Active Minds,Soccer, Accounting Club |
786543 | Sam | King | Chinese Studies,Boxing, |
873423 | Kim | Shaw | *******, Carswell, Tennis, Zeta, Golf, Presidential Scholar, Archery, Women in Science, Concert Choir |
<tbody>
</tbody>
This what I want it to look like.
58475 | Kate | Smith | Law Review |
58475 | Active Minds | ||
58475 | Soccer | ||
58475 | Accounting Club |
<tbody>
</tbody>
I am not well versed on the use of Macros. So if you can explain it like I am 5 that would be great. I truly appreciate your help as I have over 5,000 rows of data.