• Home
• Products
  Complete Product List New Products Free Products Analysis Products Charting Products Data Products Macro Books Specialty Products Time Saving Products Workbooks/Templates Products by Others iPhone Applications
• Product Collections
  Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection
• Save $'s
  Volume discounts Past customers discounts Buy a collection! Buy the Productivity Suite!
• Download
  Download Information Download Purchased Software Download Upgrades Download Trial Versions Download Free Products
• Support
  Support How to Contact Us Top Support Questions Money Back Guarantee Ordering FAQ's Product FAQ's How to Open and Use Our Products Excel Problems & Solutions Links to other Excel sites How to repair Microsoft Excel Need more help? Let us connect computers
• Company
  About Add-ins.com LLC How to Contact Us Customer Feedback Policies License Agreement

Report To Data Assistant for Microsoft® Excel® 97, 2000, 2002, 2003, 2007, and 2010 Convert report like Excel worksheets       to data tables Use the data tables to create pivot tables Create re-usable instructions Selectively extract data

The Report To Data Assistant is an add-in for Microsoft Excel. It is designed to help you convert text reports into Microsoft Excel worksheet databases. For example, if your report looks like the following:

You would be faced with deleting the title rows that repeat every 60-80 lines and all the blank lines. With the Report to Data Assistant you can easily select the title rows and blank rows and delete them. Then you can use the data filter features of Excel or the pivot table features to analyze the data.

The Report to Data Assistant can also help you extract rows from a file. When the above report is parsed into Excel the sales data ends up in column C. With the Report to Data Assistant you can select all rows with numeric entries in column C. Then you would copy these rows and paste on a new worksheet.

The main menu of the Report to Data Assistant looks like this:

A selection criteria worksheet allows you to store the row selection criteria.  The following illustrates such a worksheet:

Row 3 illustrates three conditions that must be met for the the row to be included in the selection list per that test.  Rows 4 and 5 illustrate simpler tests.  The following are the many tests that you can use:

equal to not equal to contains does not contain empty not empty greater than greater than or equal to less than less than or equal to

begins with does not begin with ends with does not end with numeric Text Date X or more cell entries X or less cell entries X cell entries

When the selection process is done, the matching rows are selected. You can copy them to another worksheet via Edit, Copy. You can delete them via Edit, Delete. If you want to examine them you can color code them for ease of inspection. Then run the selection again to re-select the rows.

The Report To Data Assistant also has options that allow you to combine multiple rows onto one row and to concatenate multiple cell entries.  

Order online from our secure service. Get delivery in minutes!

US $29.95

View Cart US $29.95 Quantity Discount 2 10% 3 20% 4 30% 5-9 40% 10 or more 50%

Order online from our
secure service
Get delivery in minutes!

Order Risk Free
Money back guarantee
if not satisfied

Buy individually or
save by buying the Productivity Suite