2 Replies Latest reply: Dec 14, 2016 11:33 AM by Karen Loomis RSS

    Looking to extract multiple lines from one detail row

    Karen Loomis

      Hello,

       

      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.

       

      Any ideas?

       

      Thanks!

       

      Karen