I'm needing some help turning a table with two columns, into a table with multiple columns based on the information in the column. The table I currently have has over 300 rows and I want to turn this:
<tbody>
</tbody>
into this:
<tbody>
</tbody>
Is this possible through a formula or a macro? I'm not too savvy with VBA, but am willing to give that a go if it would be easier. The thing that makes this difficult (at least for me) is that some IDs have multiple schools/GPAs.
Any help is greatly appreciated.
123888 | |
OTHER US | 4 |
KSU | 3.92 |
378288 | |
CHAMPAGNE-URBANA | 3.8 |
999914 | |
PORTLAND STATE | 3.4 |
DARTMOUTH | 3.6 |
NORTHWESTERN | 3.8 |
<tbody>
</tbody>
into this:
123888 | OTHER US | 4 | KSU | 3.92 | ||
378288 | CHAMPAGNE-URBANA | 3.8 | ||||
999914 | PORTLAND STATE | 3.4 | DARTMOUTH | 3.6 | NORTHWESTERN | 3.8 |
<tbody>
</tbody>
Is this possible through a formula or a macro? I'm not too savvy with VBA, but am willing to give that a go if it would be easier. The thing that makes this difficult (at least for me) is that some IDs have multiple schools/GPAs.
Any help is greatly appreciated.