Hope someone can help. I have a list of data as follows
<colgroup><col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;">
<col width="155" style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668;">
<tbody>
</tbody>
and I want to create the following table
<colgroup><col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;">
<col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4315;">
<col width="114" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;">
<col width="108" style="width: 81pt; mso-width-source: userset; mso-width-alt: 3949;" span="2">
<tbody>
</tbody>
can this be done automatically as the data set is over 10,000 lines?
Employee | Project |
AMEYV | 32710-NDIA-1000 |
AMEYV | 32687-POST-1000 |
AMEYV | 32710-NDIA-1000 |
AMEYV | 32710-NDIA-1000 |
BRADYS | 32708-CDGP-1000 |
BRADYS | 32723-FSRP-1000 |
BRADYS | 32723-FSRP-1000 |
BRADYS | 32723-FSRP-1000 |
CANDLINT | 32666-DMOS-1000 |
CANDLINT | 32666-DMOS-1000 |
CANDLINT | 32666-DMOS-1000 |
COLEC | QES5283-3223 |
COLEC | QES5283-4206 |
COLEC | QES5429-4000 |
COLEC | QES5283-4206 |
COLEC | QES5283-4206 |
COLEC | QES5283-4206 |
DAVIESCL | 32724-FSRP-1000 |
DAVIESCL | 32724-FSRP-1000 |
and I want to create the following table
Employee | Project | |||
AMEYV | 32710-NDIA-1000 | 32687-POST-1000 | ||
BRADYS | 32708-CDGP-1000 | 32723-FSRP-1000 | ||
CANDLINT | 32666-DMOS-1000 | |||
COLEC | QES5283-3223 | QES5283-4206 | QES5429-4000 | QES5283-4206 |
DAVIESCL | 32724-FSRP-1000 |
can this be done automatically as the data set is over 10,000 lines?