Hi
I have a table in the form
| NAME | AVERAGE WEIGHT | % WEIGHT | % CONTRIB | AVERAGE WEIGHT | % WEIGHT | % CONTRIB | WEIGHT DIFF | OPTION SELECT | STATUS |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
how can I convert this into the below table
| | | | TOP 10 | | | | | | |
| | | A | | | B | | | | |
| NAME | AVERAGE | % | % | AVERAGE | % | % | WEIGHT | OPTION | |
| | WEIGHT | WEIGHT | CONTRIB | WEIGHT | WEIGHT | CONTRIB | DIFF | SELECT | STATUS |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |