vds1
Well-known Member
- Joined
- Oct 5, 2011
- Messages
- 1,200
Hello Gurus,
Hope your staying safe, posting after long time.
so I have a sheet with table that contains Level, XML tag and Value in Column A, B and C respectively as shown below in Sheet named as "Master"
The output will be multi level XML tags in new sheet starting from column A
Any guidance is much appreciated.. Thank you for looking into it
Hope your staying safe, posting after long time.
so I have a sheet with table that contains Level, XML tag and Value in Column A, B and C respectively as shown below in Sheet named as "Master"
LEVEL (COLUMN A) | XML TAG (COLUMN B) | VALUE (COLUMN C) |
---|---|---|
1 | <AppHdr> | |
2 | <Fr> | |
3 | <OrgId> | |
4 | <Id> | |
5 | <OrgId> | |
6 | <Othr> | |
7 | <Id> | 50 |
2 | <To> | |
3 | <OrgId> | |
4 | <Id> | |
5 | <OrgId> | |
6 | <Othr> | |
7 | <Id> | 60 |
2 | <BMsgIdr> | MSG1 |
2 | <MDefIdr> | MSG2 |
The output will be multi level XML tags in new sheet starting from column A
<AppHdr> | |||||||
<Fr> | |||||||
<OrgId> | |||||||
<Id> 50 | |||||||
<OrgId> | |||||||
<Othr> | |||||||
<Id> 50 | |||||||
</Id> | |||||||
</Othr> | |||||||
</OrgId> | |||||||
</Id> | |||||||
</OrgId> | |||||||
</Fr> | |||||||
<To> | |||||||
<OrgId> | |||||||
<Id> 51 | |||||||
<OrgId> | |||||||
<Othr> | |||||||
<Id> 60 | |||||||
</Id> | |||||||
</Othr> | |||||||
</OrgId> | |||||||
</Id> | |||||||
</OrgId> | |||||||
</To> | |||||||
<BMsgIdr> MSG1 | |||||||
</BMsgIdr> | |||||||
<MDefIdr> MSG2 | |||||||
</MDefIdr> | |||||||
</AppHdr> |
Any guidance is much appreciated.. Thank you for looking into it