Forum Discussion
Converting hierarchy indent into columns
I have a text file with the following format Admin HR Accounts IT Support Technical Software Hardware the expected result after copying to excel Column ...
BenjaminChew Provided that the text file contains a consistent number of spaces before each sub-department, you could used Power Query to create the desired column layout. Attached a workbook with two very crude examples.