Looking to duplicate first header of a table downwards. Within a field i have a name that Id like to bring down to a certain point which comes from a table.
Then there is another table that Id like to repeat the same process over and over.
The left is the input and the right side is the desired output. How and which tool should I use to go on about this?
| ABC Fund | ABC Fund | |
| % Holding by ERISA Type | ABC Fund | |
| ERISA | ABC Fund | |
| ERISA Affiliate | ABC Fund | |
| Non ERISA Affiliate | ABC Fund | |
| Non-ERISA | ABC Fund | |
| Total | ABC Fund | |
| ABC Fund | ||
| % ERISA Assets in | ABC Fund | |
| CRA Fund | CRA Fund | |
| % Holding by ERISA Type | CRA Fund | |
| ERISA | CRA Fund | |
| ERISA Affiliate | CRA Fund | |
| Non ERISA Affiliate | CRA Fund | |
| Non-ERISA | CRA Fund | |
| Total | CRA Fund | |
| CRA Fund | ||
| % ERISA Assets in | CRA Fund | |
| EFD Fund | EFD Fund | |
| % Holding by ERISA Type | EFD Fund | |
| ERISA | EFD Fund | |
| ERISA Affiliate | EFD Fund | |
| Non ERISA Affiliate | EFD Fund | |
| Non-ERISA | EFD Fund | |
| Total | EFD Fund | |
| EFD Fund | ||
| % ERISA Assets in | EFD Fund | |
| KFC Fund | KFC Fund | |
| % Holding by ERISA Type | KFC Fund | |
| ERISA | KFC Fund | |
| ERISA Affiliate | KFC Fund | |
| Non ERISA Affiliate | KFC Fund | |
| Non-ERISA | KFC Fund | |
| Total | KFC Fund | |
| KFC Fund | ||
| % ERISA Assets in | KFC Fund |
Solved! Go to Solution.
@RNSEG Here's a solution that should work for you! You'll need to flag the Header Rows, and then use that in a Multi-Row-Formula Tool. Here's my configuration and sample output for reference.
Hope this helps! -Jay
This worked just the way I needed it to. Thank you very much for your help and a quick response!
