Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Excel Input Data Prep - Condensing a hierarchy format

JBLove
10 - Fireball

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:

 

F1F2F3F4F5
1.Interest Income:   
 a.Interest and fee income on loans:  
  (1)In domestic officesXXX
 b.Income from lease financing receivables XXX

 

 

This is what I would like it to look like:

F1F2F3F4
1.Interest Incomea.Interest and fee income on loans:(1) In domestic officesXXX
1.Interest Incomeb.Income from lease financing receivables[null]XXX

 

Any suggestions are greatly appreciated.

 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

It was a bit of a struggle but I got there in the end. Not sure if the logic is robust enough.

 

DavidP_0-1595976865042.png

 

JBLove
10 - Fireball

@DavidP  -

 

Thank you!  This is what I needed to get going in the right direction.

Labels
Top Solution Authors