JimSpringer
New Member
- Joined
- Apr 17, 2019
- Messages
- 4
I have a list generated from another program of all of the locations one person worked at. It looks like this. The order of the locations is listed randomly:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Gary[/TD]
[TD]Linda[/TD]
[TD]Marissa[/TD]
[TD]Brad[/TD]
[TD]Xavier[/TD]
[/TR]
[TR]
[TD]Lincoln[/TD]
[TD]Wausau[/TD]
[TD]Annapolis[/TD]
[TD]Laredo[/TD]
[TD]Bethesda[/TD]
[/TR]
[TR]
[TD]Laredo[/TD]
[TD][/TD]
[TD]Bethesda[/TD]
[TD]Waco[/TD]
[TD]Annapolis[/TD]
[/TR]
[TR]
[TD]St Louis[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Wausau[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I was able to get it into a format like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Brad[/TD]
[TD]Gary[/TD]
[TD]Linda[/TD]
[TD]Marissa[/TD]
[TD]Xavier[/TD]
[/TR]
[TR]
[TD]Annapolis[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Bethesda[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Laredo[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Lincoln[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]St Louis[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Waco[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Wausau[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[/TR]
</tbody>[/TABLE]
What I need to generate is a list like this one:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Annapolis[/TD]
[TD]Bethesda[/TD]
[TD]Laredo[/TD]
[TD]Lincoln[/TD]
[TD]St Louis[/TD]
[TD]Waco[/TD]
[TD]Wausau[/TD]
[/TR]
[TR]
[TD]Marissa[/TD]
[TD]Marissa[/TD]
[TD]Brad[/TD]
[TD]Gary[/TD]
[TD]Gary[/TD]
[TD]Brad[/TD]
[TD]Linda[/TD]
[/TR]
[TR]
[TD]Xavier[/TD]
[TD]Xavier[/TD]
[TD]Gary[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Xavier[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Ideally, I would generate it from the first table, without having to make the second one. I am stuck, however, on how to make this happen. It seems like it should be simple, but I can't get it to work. Asking for help.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Gary[/TD]
[TD]Linda[/TD]
[TD]Marissa[/TD]
[TD]Brad[/TD]
[TD]Xavier[/TD]
[/TR]
[TR]
[TD]Lincoln[/TD]
[TD]Wausau[/TD]
[TD]Annapolis[/TD]
[TD]Laredo[/TD]
[TD]Bethesda[/TD]
[/TR]
[TR]
[TD]Laredo[/TD]
[TD][/TD]
[TD]Bethesda[/TD]
[TD]Waco[/TD]
[TD]Annapolis[/TD]
[/TR]
[TR]
[TD]St Louis[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Wausau[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I was able to get it into a format like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Brad[/TD]
[TD]Gary[/TD]
[TD]Linda[/TD]
[TD]Marissa[/TD]
[TD]Xavier[/TD]
[/TR]
[TR]
[TD]Annapolis[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Bethesda[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[/TR]
[TR]
[TD]Laredo[/TD]
[TD]YES[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Lincoln[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]St Louis[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Waco[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]Wausau[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[/TR]
</tbody>[/TABLE]
What I need to generate is a list like this one:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Annapolis[/TD]
[TD]Bethesda[/TD]
[TD]Laredo[/TD]
[TD]Lincoln[/TD]
[TD]St Louis[/TD]
[TD]Waco[/TD]
[TD]Wausau[/TD]
[/TR]
[TR]
[TD]Marissa[/TD]
[TD]Marissa[/TD]
[TD]Brad[/TD]
[TD]Gary[/TD]
[TD]Gary[/TD]
[TD]Brad[/TD]
[TD]Linda[/TD]
[/TR]
[TR]
[TD]Xavier[/TD]
[TD]Xavier[/TD]
[TD]Gary[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Xavier[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Ideally, I would generate it from the first table, without having to make the second one. I am stuck, however, on how to make this happen. It seems like it should be simple, but I can't get it to work. Asking for help.