naveenraja16
New Member
- Joined
- Mar 3, 2016
- Messages
- 10
I am wanted to simplify the task of transforming 1000's of data in rows into a table with specified column headings. I do manual copy paste of data which is tedious.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>
with reference to the sample data available in the attached image , The data available in the bounded table on the left has to be tabulated under the headings g1 to m5 respectively. The bounded data with a thick border represents one set . That has to tabulated in the first row. Similarly the second set has to be populated in second row. The sets can be differentiated by referring the numbering of rows . every set begins with number 1 .
Can this forum help me in doing this task through a vba code.
g | l | m | |
1 | PT-55002 | 0 | 135 |
2 | PT-55002 | 0 | 135 |
3 | AIT-98932 | -200 | 150 |
4 | FT-98140 | 0 | 50 |
1 | LT-36001 | 0 | 100 |
2 | FQIT-36003 | 0 | 7000 |
3 | LT-37201 | 0 | 110 |
1 | LT-39001 | 0 | 110 |
2 | LT-41005 | 0 | 100 |
3 | LT-38002 | 0 | 100 |
4 | AIT-37705 | 0 | 20 |
5 | AIT-39510 | 0 | 100 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
g1 | l1 | m1 | g2 | l2 | m2 | g3 | l3 | m3 | g4 | l4 | m4 | g5 | l5 | m5 |
PT-55002 | 0 | 135 | PT-55002 | 0 | 135 | AIT-98932 | -200 | 150 | FT-98140 | 0 | 50 | |||
LT-36001 | 0 | 100 | FQIT-36003 | 0 | 7000 | LT-37201 | 0 | 110 | ||||||
LT-39001 | 0 | 110 | LT-41005 | 0 | 100 | LT-38002 | 0 | 100 | AIT-37705 | 0 | 20 | AIT-39510 | 0 | 100 |
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>
with reference to the sample data available in the attached image , The data available in the bounded table on the left has to be tabulated under the headings g1 to m5 respectively. The bounded data with a thick border represents one set . That has to tabulated in the first row. Similarly the second set has to be populated in second row. The sets can be differentiated by referring the numbering of rows . every set begins with number 1 .
Can this forum help me in doing this task through a vba code.
Last edited: