Report To Data Assistant for Microsoft Excel
Cost: $29
Get the full version
Trial version
Developer's Website
Descriptions
Report To Data Assistant for Microsoft Excel: The Report To Data Assistant is a Microsoft Excel add-in by Macro Systems. It is designed to help you convert text reports into Microsoft Excel worksheet databases. It can easily convert complex listings into data tables.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.
|