HI Team,
I want to arrange below table in order. If you see the 1st column have all the number. Now in C and G have common number with making of 1. Now i need both them in side to side. Same for others. All the columns should be arranged in order so i can know what are the alphabets have same numbers. For my reference i just added all the numbers in end. So i thought 1st we will arrange has per total then later arrange by number. You can ignore it if no need. My final output should be all the columns should be in order with have same numbers marked has "1"
<colgroup><col><col><col><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I want to arrange below table in order. If you see the 1st column have all the number. Now in C and G have common number with making of 1. Now i need both them in side to side. Same for others. All the columns should be arranged in order so i can know what are the alphabets have same numbers. For my reference i just added all the numbers in end. So i thought 1st we will arrange has per total then later arrange by number. You can ignore it if no need. My final output should be all the columns should be in order with have same numbers marked has "1"
Row Labels | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |
194 | ||||||||||||||||
197 | ||||||||||||||||
200 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
204 | 1 | |||||||||||||||
206 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
207 | 1 | |||||||||||||||
211 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||
212 | 1 | 1 | ||||||||||||||
213 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||
221 | 1 | 1 | 1 | |||||||||||||
223 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
227 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
228 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
229 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
230 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
232 | 1 | 1 | ||||||||||||||
Grand Total | 4 | 8 | 7 | 5 | 6 | 8 | 7 | 10 | 8 | 9 | 9 | 1 | 9 | 8 | 10 | 11 |
<colgroup><col><col><col><col><col><col span="2"><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>