Hello everyone,
I have a requirement to change the format of some data from a table to a list.
The data I have at the moment looks like this:
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]6 Jan 2018[/TD]
[TD="align: right"]5 Jan 2018[/TD]
[TD="align: right"]4 Jan 2018[/TD]
[TD="align: right"]3 Jan 2018[/TD]
[TD="align: right"]2 Jan 2018[/TD]
[TD="align: right"]1 Jan 2018[/TD]
[/TR]
[TR]
[TD]Group1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Location1[/TD]
[/TR]
[TR]
[TD]Group3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Location1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Location2[/TD]
[/TR]
[TR]
[TD]Group6[/TD]
[TD]Location5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group7[/TD]
[TD][/TD]
[TD][/TD]
[TD]Location6[/TD]
[TD][/TD]
[TD]Location3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group8[/TD]
[TD][/TD]
[TD][/TD]
[TD]Location2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The required list looks like this (the column ordering is not important):
[TABLE="class: grid"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Group[/TD]
[/TR]
[TR]
[TD]1 Jan 2018[/TD]
[TD]Location1[/TD]
[TD]Group2[/TD]
[/TR]
[TR]
[TD]1 Jan 2018[/TD]
[TD]Location2[/TD]
[TD]Group5[/TD]
[/TR]
[TR]
[TD]2 Jan 2018[/TD]
[TD]Location3[/TD]
[TD]Group7[/TD]
[/TR]
[TR]
[TD]3 Jan 2018[/TD]
[TD]Location1[/TD]
[TD]Group3[/TD]
[/TR]
[TR]
[TD]4 Jan 2018[/TD]
[TD]Location6[/TD]
[TD]Group7[/TD]
[/TR]
[TR]
[TD]4 Jan 2018[/TD]
[TD]Location2[/TD]
[TD]Group8[/TD]
[/TR]
[TR]
[TD]6 Jan 2018[/TD]
[TD]Location5[/TD]
[TD]Group6[/TD]
[/TR]
</tbody>[/TABLE]
I'd have thought I'd be able to find something I could use in the forum, but my searches based on words like "table" and "list" don't seem to bring up anything relevant.
Any help is greatly appreciated!
I have a requirement to change the format of some data from a table to a list.
The data I have at the moment looks like this:
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]6 Jan 2018[/TD]
[TD="align: right"]5 Jan 2018[/TD]
[TD="align: right"]4 Jan 2018[/TD]
[TD="align: right"]3 Jan 2018[/TD]
[TD="align: right"]2 Jan 2018[/TD]
[TD="align: right"]1 Jan 2018[/TD]
[/TR]
[TR]
[TD]Group1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Location1[/TD]
[/TR]
[TR]
[TD]Group3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Location1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Location2[/TD]
[/TR]
[TR]
[TD]Group6[/TD]
[TD]Location5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group7[/TD]
[TD][/TD]
[TD][/TD]
[TD]Location6[/TD]
[TD][/TD]
[TD]Location3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group8[/TD]
[TD][/TD]
[TD][/TD]
[TD]Location2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Group9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The required list looks like this (the column ordering is not important):
[TABLE="class: grid"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Group[/TD]
[/TR]
[TR]
[TD]1 Jan 2018[/TD]
[TD]Location1[/TD]
[TD]Group2[/TD]
[/TR]
[TR]
[TD]1 Jan 2018[/TD]
[TD]Location2[/TD]
[TD]Group5[/TD]
[/TR]
[TR]
[TD]2 Jan 2018[/TD]
[TD]Location3[/TD]
[TD]Group7[/TD]
[/TR]
[TR]
[TD]3 Jan 2018[/TD]
[TD]Location1[/TD]
[TD]Group3[/TD]
[/TR]
[TR]
[TD]4 Jan 2018[/TD]
[TD]Location6[/TD]
[TD]Group7[/TD]
[/TR]
[TR]
[TD]4 Jan 2018[/TD]
[TD]Location2[/TD]
[TD]Group8[/TD]
[/TR]
[TR]
[TD]6 Jan 2018[/TD]
[TD]Location5[/TD]
[TD]Group6[/TD]
[/TR]
</tbody>[/TABLE]
I'd have thought I'd be able to find something I could use in the forum, but my searches based on words like "table" and "list" don't seem to bring up anything relevant.
Any help is greatly appreciated!