subhojyoti
New Member
- Joined
- Nov 12, 2018
- Messages
- 3
Hi,
I'm new to Excel Scripting.
I need help to create below parent child relationship in excel. I have the source file in below format.
<colgroup><col span="4"></colgroup><tbody>
</tbody>
And my output needs to be like this
<colgroup><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
I'm new to Excel Scripting.
I need help to create below parent child relationship in excel. I have the source file in below format.
Level1 | Level2 | Level3 | Level4 |
PC_BMROA | CD_KENBM | 24158 | 009 |
PC_BMROA | CD_KENBM | 24158 | 010 |
PC_BMROA | CD_KENBM | 24158 | 011 |
PC_BMROA | CD_KENBM | 24158 | 012 |
PC_BMROA | CD_KENBM | 24158 | 013 |
PC_BMROA | CD_KENBM | 24158 | 014 |
PC_BMROA | CD_KENBM | 24158 | 015 |
PC_BMROA | CD_KENBM | 24158 | 072 |
<colgroup><col span="4"></colgroup><tbody>
</tbody>
And my output needs to be like this
Parent | Child |
PC_BMROA | CD_KENBM |
CD_KENBM | 24158 |
24158 | 009 |
24158 | 010 |
24158 | 011 |
24158 | 012 |
24158 | 013 |
24158 | 014 |
24158 | 015 |
24158 | 072 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Any help is appreciated. The number of rows will be dynamic but column can remain the same. |
<colgroup><col><col></colgroup><tbody>
</tbody>