Split indented Hierarchy list into columns

I have a list in a single column that has an indented hierarchy structure and I would like to split it to columns. each level have another indent.
the problem is that the indent is for display only and not regular space in the cell.
power query see it without the indents.
i will appreciate your help with that.
thanks,

now with the attached file.

column B is just to help explain.

VBA, if you like.

Please Login or Register  to view this content.

WOW!!! this is perfect!!
You are the best!
thank you

Originally Posted by Glenn Kennedy

Hi Jindon/Andy Pope, I don't think that there is an alternative!! I've seen you do something similar before. Way beyond my abilities!!!

I thought so.
Normally I don't post here, but this time...

Awesome..!
Thanks a million..!!
Further, request you to please help me with the following: (sample excel sheet attached)

Coulmn A : Indented texts upto 3 levels
Column B, C, D : Texts corresponding to Indent level 0
Column E, F, G : Digits/ blank cells/ (N/A)

Pls help me out in separating the indented texts in different cells and retaining corresponding data in other columns.

Hi Jindon,
I looked at the file you provided for the other user, but it didn't work when I copied and pasted my data into the file.

I think this is because I have more columns with other data besides the indented file list.

Would it be possible to recreate the VBA script specific to my file/data? The full file has more than 80,000 rows!

I don't know anything about VBAs or macros so appreciate the help in advance.

Thank you!

boyerusmc,

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

And when you open a new thread, posting workbook with data and your desired result would help very much.

Understood, thank you Jindon. It's not exactly clear how to start a new thread - do I need to buy points? The link you gave me does not give instructions to post a new thread.

Click Excel General
Then you will see [+Post New Thread]