Hi folks,
I'm looking to find the best way of going about taking contents from a bunch of single cells and output them to multiple rows.
Column A - Ticket Number
Column B - Application Name
Column C - User Name(s)
Column A and B always contain a single value per cell. Each cell in Coumn C, however, contains 1 or more User Names. The ones that contain multiple names are formatted in such a way that each User Name is on the next line - but all within a single cell.
Below is an example.. The first row, for example, contains 3 distinct User Names in Column C; the second row only contains 1; third row contains 4
Since there's a total of 8 User Names between those three rows, my desired result is to have them split out into 8 rows
Thoughts?
Current Format:
<tbody>
</tbody>
Desired Result:
<tbody>
</tbody>
I'm looking to find the best way of going about taking contents from a bunch of single cells and output them to multiple rows.
Column A - Ticket Number
Column B - Application Name
Column C - User Name(s)
Column A and B always contain a single value per cell. Each cell in Coumn C, however, contains 1 or more User Names. The ones that contain multiple names are formatted in such a way that each User Name is on the next line - but all within a single cell.
Below is an example.. The first row, for example, contains 3 distinct User Names in Column C; the second row only contains 1; third row contains 4
Since there's a total of 8 User Names between those three rows, my desired result is to have them split out into 8 rows
Thoughts?
Current Format:
Ticket # | Application Name | Username(s) |
P100 | Finance | jdoe csmith ajohnson |
P101 | Payroll | jjones |
P102 | Finance | rsmith aking2 fmoore lparker |
<tbody>
</tbody>
Desired Result:
Ticket # | Application Name | Username(s) |
P100 | Finance | jdoe |
P100 | Finance | csmith |
P100 | Finance | ajohnson |
P101 | Payroll | jjones |
P102 | Finance | rsmith |
P102 | Finance | aking2 |
P102 | Finance | fmoore |
P102 | Finance | lparker |
<tbody>
</tbody>