Hey Everyone, I've tried to answer this on my own, without any success, so I come to you wonderful Excel masters...
I have a simple spreadsheet with two columns, the A row contains the ID of the person and the B row contains their goals (1-6 or so) which I have exported from sharepoint. Unfortunately, they are massive (and some have line breaks or other characters), but concatenated with a ~. I want to split them into multiple rows for each goal with the ID being copied for each new row created.
Hopefully this snippet helps, this is the source and the second one is what I would like it to look like after running the macro.
<tbody>
</tbody>
Would look like this:
<tbody>
</tbody>...and so on.
Thank YOU!!!!!!!!
I have a simple spreadsheet with two columns, the A row contains the ID of the person and the B row contains their goals (1-6 or so) which I have exported from sharepoint. Unfortunately, they are massive (and some have line breaks or other characters), but concatenated with a ~. I want to split them into multiple rows for each goal with the ID being copied for each new row created.
Hopefully this snippet helps, this is the source and the second one is what I would like it to look like after running the macro.
<colgroup><col width="175"></colgroup><tbody> </tbody> |
<colgroup><col width="568"></colgroup><tbody> </tbody> | ||
1 |
<colgroup><col width="568"></colgroup><tbody> </tbody> | ||
2 |
<colgroup><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>
Would look like this:
EmployeeAccount |
<tbody> </tbody> | |
1 | Serve as Project Manager for at least two 2013 events including: developing budgets, managing staff work plan, leading weekly event meetings, serving as main contact for vendors, and being recognized by peers as the staff lead on the event due to familiarity with details. | |
1 | Deepen overall knowledge of Foundation by attending at least six Foundation team meetings outside of main responsibilities by December 2012. | |
1 | Serve as primary event contact for third party auctions. |
<tbody>
</tbody>
Thank YOU!!!!!!!!