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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD][/TD]
[TD]B
[/TD]
[TD][/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]Z
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Z
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And I'm looking to turn it into this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD][/TD]
[TD]B
[/TD]
[TD][/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]Z
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD][/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD][/TD]
[TD]B
[/TD]
[TD][/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]Z
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Z
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And I'm looking to turn it into this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD][/TD]
[TD]B
[/TD]
[TD][/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]Z
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD][/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]