|
A |
B |
2 |
|
Instructions |
3 |
1 |
Calc number of preceding spaces |
4 |
2 |
Convert PreSpaces to units (4 each), ignoring 1st |
5 |
3 |
Replace PreSpaces with pipe characters | |
6 |
4 |
Convert that column to values |
7 |
5 |
Run Text-to-columns, using the pipe as a delimiter |
8 |
6 |
Put heading labels for Level_1 through Level_12 |
9 |
7 |
Select blank cells in the Text-to-columns destination range |
10 |
|
• Home.Find&select.Go_To...Click: Special cells...Check: Blanks...Click: OK |
11 |
|
• H2 will be the active cell |
12 |
8 |
Enter this formula in H2 and press CTRL+ENTER, to automatically propagate that formula in every selected cell |
13 |
9 |
=IF(LEFT(H1,5)="level","",IF(COLUMNS($G:H)<=($D2+1),H1&"","")) |
14 |
|
|
15 |
|
The end result is what you want....convert all of the formulas to values OR Copy/Paste_Special.Values to another tab |
Bookmarks