Hi - I am consolidating an Excel workbook spanning multiple tabs with data containing varying levels of hierarchy.
While I've got the Macro figured out in sourcing the data, I am struggling with collapsing the hierarchy structure into the desired format.
Here's an example of what the data looks like:
F1 | F2 | F3 | F4 | F5 |
1. | Interest Income: | |||
a. | Interest and fee income on loans: | |||
(1) | In domestic offices | XXX | ||
b. | Income from lease financing receivables | XXX |
This is what I would like it to look like:
F1 | F2 | F3 | F4 |
1.Interest Income | a.Interest and fee income on loans: | (1) In domestic offices | XXX |
1.Interest Income | b.Income from lease financing receivables | [null] | XXX |
Any suggestions are greatly appreciated.
Solved! Go to Solution.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |