jwalkerack
Board Regular
- Joined
- Jun 19, 2013
- Messages
- 81
Hi there ,
everyone , i was wondering if anyone has some ideas on the best way of sorting a table on row inputs.
What i have is a table that has a many columns of information . The columns are in sections , i have used the example of a race details. There is a row of data for each race. Then there are entries for each person, in blocks of for, the person ID for the race , the person , the start time and finsh time. At the order of how each column within each row is unordered. i have pasted in an example below.
[TABLE="width: 1214"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81><COL style="WIDTH: 48pt" span=4 width=64><TBODY>[TR]
[TD="class: xl73, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl74, width: 295, bgcolor: transparent, colspan: 4"]1[/TD]
[TD="class: xl74, width: 362, bgcolor: transparent, colspan: 4"]2[/TD]
[TD="class: xl74, width: 356, bgcolor: transparent, colspan: 4"]3[/TD]
[TD="class: xl74, width: 283, bgcolor: transparent, colspan: 4"]4[/TD]
[TD="class: xl74, width: 256, bgcolor: transparent, colspan: 4"]5[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl77, bgcolor: #ffc000"]Finsh Time[/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: #fabf8f"]1[/TD]
[TD="class: xl72, bgcolor: yellow"]1[/TD]
[TD="class: xl69, bgcolor: yellow"]John[/TD]
[TD="class: xl67, bgcolor: yellow"]10[/TD]
[TD="class: xl67, bgcolor: yellow"]60[/TD]
[TD="class: xl67, bgcolor: yellow"]2[/TD]
[TD="class: xl67, bgcolor: yellow"]Jim[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl67, bgcolor: yellow"]200[/TD]
[TD="class: xl67, bgcolor: yellow"]3[/TD]
[TD="class: xl67, bgcolor: yellow"]James[/TD]
[TD="class: xl67, bgcolor: yellow"]0[/TD]
[TD="class: xl67, bgcolor: yellow"]600[/TD]
[TD="class: xl67, bgcolor: yellow"]4[/TD]
[TD="class: xl67, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl67, bgcolor: yellow"]60[/TD]
[TD="class: xl67, bgcolor: yellow"]360[/TD]
[TD="class: xl67, bgcolor: yellow"]5[/TD]
[TD="class: xl67, bgcolor: yellow"]Jennifer[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl79, bgcolor: yellow"]600[/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: #fabf8f"]2[/TD]
[TD="class: xl71, bgcolor: yellow"]6[/TD]
[TD="class: xl67, bgcolor: yellow"]James[/TD]
[TD="class: xl67, bgcolor: yellow"]10[/TD]
[TD="class: xl67, bgcolor: yellow"]120[/TD]
[TD="class: xl67, bgcolor: yellow"]7[/TD]
[TD="class: xl67, bgcolor: yellow"]Jim[/TD]
[TD="class: xl67, bgcolor: yellow"]30[/TD]
[TD="class: xl67, bgcolor: yellow"]150[/TD]
[TD="class: xl67, bgcolor: yellow"]8[/TD]
[TD="class: xl67, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl67, bgcolor: yellow"]50[/TD]
[TD="class: xl67, bgcolor: yellow"]150[/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl79, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: #fabf8f"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl79, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: #fabf8f"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl83, bgcolor: yellow"] [/TD]
[/TR]
</TBODY>[/TABLE]
i would like to be able to have my the able so it is formatted so all of the entries are columinised. i was intially thinking that i could do this by ordering the inputs alphabetically. But this would only give the ranges as they come in.
My ideal output would be comes as below , so its alphabetical and ordered in a column fashion , with all the james in a column and all the Jims in the same column of data.
Any ideas on the best functions formulas to use ?, thanks very much
[TABLE="width: 1214"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81><COL style="WIDTH: 48pt" span=4 width=64><TBODY>[TR]
[TD="class: xl69, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl70, width: 295, bgcolor: transparent, colspan: 4"]1[/TD]
[TD="class: xl70, width: 362, bgcolor: transparent, colspan: 4"]2[/TD]
[TD="class: xl70, width: 356, bgcolor: transparent, colspan: 4"]3[/TD]
[TD="class: xl70, width: 283, bgcolor: transparent, colspan: 4"]4[/TD]
[TD="class: xl70, width: 256, bgcolor: transparent, colspan: 4"]5[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl72, bgcolor: #ffc000"]Finsh Time[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: #fabf8f"]1[/TD]
[TD="class: xl67, bgcolor: yellow"]3[/TD]
[TD="class: xl67, bgcolor: yellow"]James[/TD]
[TD="class: xl67, bgcolor: yellow"]0[/TD]
[TD="class: xl67, bgcolor: yellow"]600[/TD]
[TD="class: xl67, bgcolor: yellow"]5[/TD]
[TD="class: xl67, bgcolor: yellow"]Jennifer[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl67, bgcolor: yellow"]600[/TD]
[TD="class: xl67, bgcolor: yellow"]2[/TD]
[TD="class: xl67, bgcolor: yellow"]Jim[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl67, bgcolor: yellow"]200[/TD]
[TD="class: xl67, bgcolor: yellow"]4[/TD]
[TD="class: xl67, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl67, bgcolor: yellow"]60[/TD]
[TD="class: xl67, bgcolor: yellow"]360[/TD]
[TD="class: xl67, bgcolor: yellow"]1[/TD]
[TD="class: xl67, bgcolor: yellow"]John[/TD]
[TD="class: xl67, bgcolor: yellow"]10[/TD]
[TD="class: xl73, bgcolor: yellow"]60[/TD]
[/TR]
[TR]
[TD="class: xl75, bgcolor: #fabf8f"]2[/TD]
[TD="class: xl76, bgcolor: yellow"]6[/TD]
[TD="class: xl76, bgcolor: yellow"]James[/TD]
[TD="class: xl76, bgcolor: yellow"]10[/TD]
[TD="class: xl76, bgcolor: yellow"]120[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: yellow"]7[/TD]
[TD="class: xl76, bgcolor: yellow"]Jim[/TD]
[TD="class: xl76, bgcolor: yellow"]30[/TD]
[TD="class: xl76, bgcolor: yellow"]150[/TD]
[TD="class: xl76, bgcolor: yellow"]8[/TD]
[TD="class: xl76, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl76, bgcolor: yellow"]50[/TD]
[TD="class: xl76, bgcolor: yellow"]150[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]
everyone , i was wondering if anyone has some ideas on the best way of sorting a table on row inputs.
What i have is a table that has a many columns of information . The columns are in sections , i have used the example of a race details. There is a row of data for each race. Then there are entries for each person, in blocks of for, the person ID for the race , the person , the start time and finsh time. At the order of how each column within each row is unordered. i have pasted in an example below.
[TABLE="width: 1214"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81><COL style="WIDTH: 48pt" span=4 width=64><TBODY>[TR]
[TD="class: xl73, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl74, width: 295, bgcolor: transparent, colspan: 4"]1[/TD]
[TD="class: xl74, width: 362, bgcolor: transparent, colspan: 4"]2[/TD]
[TD="class: xl74, width: 356, bgcolor: transparent, colspan: 4"]3[/TD]
[TD="class: xl74, width: 283, bgcolor: transparent, colspan: 4"]4[/TD]
[TD="class: xl74, width: 256, bgcolor: transparent, colspan: 4"]5[/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl77, bgcolor: #ffc000"]Finsh Time[/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: #fabf8f"]1[/TD]
[TD="class: xl72, bgcolor: yellow"]1[/TD]
[TD="class: xl69, bgcolor: yellow"]John[/TD]
[TD="class: xl67, bgcolor: yellow"]10[/TD]
[TD="class: xl67, bgcolor: yellow"]60[/TD]
[TD="class: xl67, bgcolor: yellow"]2[/TD]
[TD="class: xl67, bgcolor: yellow"]Jim[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl67, bgcolor: yellow"]200[/TD]
[TD="class: xl67, bgcolor: yellow"]3[/TD]
[TD="class: xl67, bgcolor: yellow"]James[/TD]
[TD="class: xl67, bgcolor: yellow"]0[/TD]
[TD="class: xl67, bgcolor: yellow"]600[/TD]
[TD="class: xl67, bgcolor: yellow"]4[/TD]
[TD="class: xl67, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl67, bgcolor: yellow"]60[/TD]
[TD="class: xl67, bgcolor: yellow"]360[/TD]
[TD="class: xl67, bgcolor: yellow"]5[/TD]
[TD="class: xl67, bgcolor: yellow"]Jennifer[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl79, bgcolor: yellow"]600[/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: #fabf8f"]2[/TD]
[TD="class: xl71, bgcolor: yellow"]6[/TD]
[TD="class: xl67, bgcolor: yellow"]James[/TD]
[TD="class: xl67, bgcolor: yellow"]10[/TD]
[TD="class: xl67, bgcolor: yellow"]120[/TD]
[TD="class: xl67, bgcolor: yellow"]7[/TD]
[TD="class: xl67, bgcolor: yellow"]Jim[/TD]
[TD="class: xl67, bgcolor: yellow"]30[/TD]
[TD="class: xl67, bgcolor: yellow"]150[/TD]
[TD="class: xl67, bgcolor: yellow"]8[/TD]
[TD="class: xl67, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl67, bgcolor: yellow"]50[/TD]
[TD="class: xl67, bgcolor: yellow"]150[/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl79, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: #fabf8f"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl67, bgcolor: yellow"] [/TD]
[TD="class: xl79, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: #fabf8f"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl82, bgcolor: yellow"] [/TD]
[TD="class: xl83, bgcolor: yellow"] [/TD]
[/TR]
</TBODY>[/TABLE]
i would like to be able to have my the able so it is formatted so all of the entries are columinised. i was intially thinking that i could do this by ordering the inputs alphabetically. But this would only give the ranges as they come in.
My ideal output would be comes as below , so its alphabetical and ordered in a column fashion , with all the james in a column and all the Jims in the same column of data.
Any ideas on the best functions formulas to use ?, thanks very much
[TABLE="width: 1214"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4315" width=118><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81><COL style="WIDTH: 48pt" span=4 width=64><TBODY>[TR]
[TD="class: xl69, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl70, width: 295, bgcolor: transparent, colspan: 4"]1[/TD]
[TD="class: xl70, width: 362, bgcolor: transparent, colspan: 4"]2[/TD]
[TD="class: xl70, width: 356, bgcolor: transparent, colspan: 4"]3[/TD]
[TD="class: xl70, width: 283, bgcolor: transparent, colspan: 4"]4[/TD]
[TD="class: xl70, width: 256, bgcolor: transparent, colspan: 4"]5[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Finsh Time[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person_id[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Person[/TD]
[TD="class: xl68, bgcolor: #ffc000"]Start time[/TD]
[TD="class: xl72, bgcolor: #ffc000"]Finsh Time[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: #fabf8f"]1[/TD]
[TD="class: xl67, bgcolor: yellow"]3[/TD]
[TD="class: xl67, bgcolor: yellow"]James[/TD]
[TD="class: xl67, bgcolor: yellow"]0[/TD]
[TD="class: xl67, bgcolor: yellow"]600[/TD]
[TD="class: xl67, bgcolor: yellow"]5[/TD]
[TD="class: xl67, bgcolor: yellow"]Jennifer[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl67, bgcolor: yellow"]600[/TD]
[TD="class: xl67, bgcolor: yellow"]2[/TD]
[TD="class: xl67, bgcolor: yellow"]Jim[/TD]
[TD="class: xl67, bgcolor: yellow"]100[/TD]
[TD="class: xl67, bgcolor: yellow"]200[/TD]
[TD="class: xl67, bgcolor: yellow"]4[/TD]
[TD="class: xl67, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl67, bgcolor: yellow"]60[/TD]
[TD="class: xl67, bgcolor: yellow"]360[/TD]
[TD="class: xl67, bgcolor: yellow"]1[/TD]
[TD="class: xl67, bgcolor: yellow"]John[/TD]
[TD="class: xl67, bgcolor: yellow"]10[/TD]
[TD="class: xl73, bgcolor: yellow"]60[/TD]
[/TR]
[TR]
[TD="class: xl75, bgcolor: #fabf8f"]2[/TD]
[TD="class: xl76, bgcolor: yellow"]6[/TD]
[TD="class: xl76, bgcolor: yellow"]James[/TD]
[TD="class: xl76, bgcolor: yellow"]10[/TD]
[TD="class: xl76, bgcolor: yellow"]120[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: yellow"]7[/TD]
[TD="class: xl76, bgcolor: yellow"]Jim[/TD]
[TD="class: xl76, bgcolor: yellow"]30[/TD]
[TD="class: xl76, bgcolor: yellow"]150[/TD]
[TD="class: xl76, bgcolor: yellow"]8[/TD]
[TD="class: xl76, bgcolor: yellow"]Joanna[/TD]
[TD="class: xl76, bgcolor: yellow"]50[/TD]
[TD="class: xl76, bgcolor: yellow"]150[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]