selant
Board Regular
- Joined
- Mar 26, 2009
- Messages
- 109
In my file, each data group consists of 4 members. There are lots of groups in my worksheet.
Here is a demo data of first 3 group. "1" , "2" , "3" indicates unique flights.
<tbody>
</tbody>
I want to convert the data to a new table such as following :
<tbody>
</tbody>
I need some help for a script or such thing to convert the first table to the requested one.
Here is a demo data of first 3 group. "1" , "2" , "3" indicates unique flights.
1 | DATA1 | MEMBER1 |
1 | DATA1 | MEMBER2 |
1 | DATA1 | MEMBER3 |
1 | DATA1 | MEMBER4 |
2 | DATA2 | MEMBER5 |
2 | DATA2 | MEMBER6 |
2 | DATA2 | MEMBER7 |
2 | DATA2 | MEMBER8 |
3 | DATA3 | MEMBER9 |
3 | DATA3 | MEMBER10 |
3 | DATA3 | MEMBER11 |
3 | DATA3 | MEMBER12 |
<tbody>
</tbody>
I want to convert the data to a new table such as following :
1 | DATA1 | MEMBER1 | MEMBER2 | MEMBER3 | MEMBER4 |
2 | DATA2 | MEMBER5 | MEMBER6 | MEMBER7 | MEMBER8 |
3 | DATA3 | MEMBER9 | MEMBER10 | MEMBER11 | MEMBER12 |
<tbody>
</tbody>
I need some help for a script or such thing to convert the first table to the requested one.