Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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