logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Columns & Rows » Put together rows or columns from several sheets...

This utility will copy the specified columns or rows from each selected sheet, and combines them into a new sheet.
You can for example put the data from F of each selected worksheet side by side on a new worksheet.

1. Select the desired worksheets from which you want to combine the data.
2. Start this utility and then select the column(s) or row(s) you wish to put together.

If you choose the option "Create dynamic links (cell references)", the new worksheet will contain formulas with a cell reference to the original data. If you choose this option the display of zero values on the new worksheet will be turned off. The display of zero values is an Excel worksheet setting which you can also control with the "Vision Control" utility in ASAP Utilities.


Example screenshot: Put together rows or columns from several sheets
Put together rows or columns from several sheets

Starting this utility

In the Excel menu choose: ASAP Utilities » Columns & Rows » Put together rows or columns from several sheets...

« Return to the list of “Columns & Rows” tools.
« Previous
The paper saver (split columns)...
 Next »
Delete unused empty ending rows/columns
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
Concatenate, Combine, Multiple Worksheets Into One Sheet, Combining, join, consolidate, combination, copy data from different sheets to one master sheet, merge sheets, combines, consolidation, stack columns

Follow ASAP Utilities on Facebook

Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2018 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook