Mar 11 2022 11:28 PM
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 |
Mar 12 2022 12:38 AM - edited Mar 12 2022 12:47 AM
@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.