Extract Data for Microsoft Excel will help you to extract the selected rows and convert them to columns. You can choose to extract entire rows or selected columns only. You can extract each row to an individual worksheet or all rows to one worksheet and group the extracted data by a specified column. With this tool you can easily change the way your Excel data is laid out, make it easy to print, review or analyze.
There are many tasks that this helpful add-in can automate for you:
Group records and export each group to a separate spreadsheet
Present your data in a questionnaire way to make them easy to print
Group the extracted information by the selected column
Or copy row data to separate worksheets
If you need to rearrange the contents of your Excel table in a handy way for analysis or to make it more convenient for printing, Extract Data is exactly what you need.
The add-in works with Microsoft Excel 2010 32-bit and 64-bit, 2007, 2003.
ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...