Hierarchy output

vinothkumar1990 

im not sure if this would help  : 

go to power query ,

use the split by column feature : 

you will have the following :

Again -->  split by columns -->  by delimiter -->  

you will have the bfollowing : 

last step : 

select Map-2 column, --> split by columns -->  by delimiter -->  

final result : 

if this is not what you are looking for , please share an example of the output you want . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠