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 1 | Column 2 | Column 3 |
| Admin | HR | |
| Admin | Accounts | |
| IT | Support | |
| IT | Technical | |
| IT | Technical | Software |
| IT | Technical | Hardware |
1 Reply
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.
