I have a large data set that is arranged something like shown below with a space between each data entry. I'd like to rearrange the data in a normal table, with the field labels across the top and each entry as a row. The main issue is that the entries aren't entirely consistent. I'm having trouble coming up with a solution (VBA or otherwise) to rearrange the data. Any help would really be appreciated.
Thanks!
<tbody>
</tbody>
Thanks!
Field 1 | Data |
Field 2 | Data |
Field 3 | Data |
Field 1 | Data |
Field 2 | Data |
Field 3 | Data |
Field 1 | Data |
Field A | Data |
Field 2 | Data |
Field 3 | Data |
Field 1 | Data |
Field A | Data |
Field B | Data |
Field 3 | Data |
<tbody>
</tbody>