This content has been marked as final. Show 2 replies
I have a pivot table type Excel file and would like "pull out" a separate row for each new column of information.
First, do I need to save the Excel file as a PDF to do this?
Second, I'd like to know how to create separate detail rows for each new column of information.
Here an example of how the data is set up:
ACCOUNTS /ENTITY 1 DETAIL/ENTITY 2 DETAIL/ENTITY 3 DETAIL...
So for each entity, I would like to pull out the account/entity name and the balance.