gilbertgrape87
New Member
- Joined
- Apr 26, 2018
- Messages
- 2
Hey everyone. Just wanted to started saying off by thanks! This forum has been invaluable whenever I am looking for solutions to problems.
This time though, I'm having trouble finding a good solution.
I have some poorly formatted data that I would like to be able to index, so I am trying to consolidate it.
Any ideas would be greatly appreciated! Thanks in advance!
Gilbert
Essentially, I have a table that looks like this:
<tbody>
</tbody>
And I'm looking to turn it into this:
<tbody>
</tbody>
This time though, I'm having trouble finding a good solution.
I have some poorly formatted data that I would like to be able to index, so I am trying to consolidate it.
Any ideas would be greatly appreciated! Thanks in advance!
Gilbert
Essentially, I have a table that looks like this:
A | B | C | ||||
X | 1 | 2 | ||||
X | 3 | 4 | ||||
Y | 3 | 4 | ||||
Y | 5 | 6 | ||||
Z | 1 | 4 | ||||
Z | 5 |
<tbody>
</tbody>
And I'm looking to turn it into this:
A | B | C | ||||
X | 1 | 2 | 3 | 4 | ||
Y | 3 | 4 | 5 | 6 | ||
Z | 1 | 4 | 5 |
<tbody>
</tbody>