Need Help on Loading Hierarchical Data

[agni_gold]

Hi All ,

I am attaching sample data here , which has source sheet , in which i have source data,

And Result Sheet contain , required result.

Please help on writing the back end script.

Thanks