I'm trying to manipulate a very large file into a new format so I can work with it in Visio.
For context, it's a succession planning file, where each current incumbent has their own row, but with each successor they add a row. For example:
<tbody>
</tbody>
However, what I'd like is to have one row for Jane and then multiple columns for the Successors:
<tbody>
</tbody>
Does anyone have any suggestions on how to do this aside from manually copying and pasting? The file has thousands of rows, so any way to automate this would be a HUGE time saver!
TIA!
For context, it's a succession planning file, where each current incumbent has their own row, but with each successor they add a row. For example:
Current Incumbent | Successor |
Jane Doe | Bob Smith |
Jane Doe | Robert Jones |
Jane Doe | Bobby Brown |
<tbody>
</tbody>
However, what I'd like is to have one row for Jane and then multiple columns for the Successors:
Current Incumbent | Successor 1 | Successor 2 | Successor 3 |
Jane Doe | Bob Smith | Robert Jones | Bobby Brown |
<tbody>
</tbody>
Does anyone have any suggestions on how to do this aside from manually copying and pasting? The file has thousands of rows, so any way to automate this would be a HUGE time saver!
TIA!