Consolidate numeric data in Excel

Hi Shaheed,

Thank you for your comment.

For us to be able to help you better, please send us a small sample workbook with your source data and the result you expect to get at support@ablebits.com. I kindly ask you to shorten the tables to 10-20 rows.

Please note that the result sheet is of great importance and often gives us a better understanding of your task rather than any text description. So don't forget to include it.

We'll look into your task and see if our software can help.

Hello Emarcee,

All our Excel add-ins are available as a part of Ultimate Suite that you can install in a trial mode and check how the tools work. Here is the direct download link for you: https://www.ablebits.com/files/get.php?addin=xl-suite&f=free-trial

Moreover, there is a user manual for each tool included in Ultimate Suite. You can open it by clicking on the corresponding link, run the tool in Excel and click the F1 button at the bottom of the add-in pane/window to have the help page open for this particular tool.

Hope you’ll find our software helpful.

Hello,

Thank you for contacting us.

For us to be able to help you better, please email us at support@ablebits.com with a detailed description of your task and a sample workbook containing 3 sheets: Sheet 1 and Sheet 2 - your source data and Sheet 3 - the result you expect to get. Please shorten the tables to 10-20 rows and replace any confidential information with some irrelevant data.

Добрый день, Екатерина.

Спасибо за вопрос. Наш Copy Sheets может Вам помочь, однако, из-за большого обьема данных мы рекомендуем обарбатывть таблицы группами. Опция Add Files на втором шаге позволит быстро добавлять нужные файлы.

Hello Aaron,
Thank you for contacting us.

The thing is, we have rearranged and renamed some of the tools in newer versions of our add-in. The option you're looking for is now located in the Copy Sheets tool. We've replied your original request via email as well, please check your Inbox. Thank you.

Hello Brandy,
Thank you for contacting us.

I'm sorry, but our Consolidate Sheets doesn't preserve formatting at the moment. If however, you use Combine Sheets to group your data, there is an option to preserve the formatting of the original data. Please try it, maybe it will work even better for you.

Hi Pamela,
Thank you for contacting us. The tool to solve your task is Merge Tables Wizard.
Open your sheets, go to the Ablebits Data tab and click on the Merge Two Tables icon.
1. On step 1 and 2 select your sheets.
2. On step 3 pick the following columns:
Invoice No.
Client ID
invoice amount
These are your matching columns.
3. Skip step 4, i.e. do not pick any columns on this step and just click the Next button.
4. On step 5 select the column(s) you want to add:
Client Name
Gross Invoice Amount
5. On step 6 read the additional options and decide which of them to tick.
Please do not hesitate to contact us with any other questions!

Hi, Natricia,
Thank you for your comment.
Your task can be easily solved with the help of two Ablebits tools, both are part of Ultimate Suite for Excel: Combine Sheets and Merge Duplicates.
Please take the following steps:
1. Open the sheets you want to combine.
2. Find the Combine Sheets icon in the Merge group under the Ablebits Data tab.
3. On the first step, check both sheets you need to combine.
4. Select the columns: ID and other columns you want to see combined.
5. Step 3: Select additional options or simply click Next.
6. Select the place to locate your merged data.
As a result, you will get a new worksheet with duplicate IDs and data from your other columns.
To get rid of the duplicate IDs and get your data combined, please use Merge Duplicates:
1. Select your new table and run Merge Duplicates, you can find its icon right near Combine Sheets in the same Merge group.
2. On step 2, choose only one key column with duplicate records: ID.
3. On step 3, check columns with data you want to combine and click the Finish button.

Thus you will get the sheets combined the way you need!

Natricia, hi again,
Actually, there is an even simpler solution for your task: the Merge Two Tables wizard!
1. On step 1 and 2 select your sheets.
2. On step 3 pick the ID column (it is “matching column”).
3. Skip step 4, i.e. do not pick any columns on this step and just click the Next button.
4. On step 5 select the column(s) you want to add.
5. On step 6 you may leave the default setting.
I hope you will find this solution helpful.

Hi, Denise,
Thank you for your question.
Your task can be easily solved with the help of two Ablebits tools, both are part of Ultimate Suite for Excel: Combine Sheets and Merge Duplicates.

Please take the following steps:
1. Open all the reports you want to combine: 2016, 2017, 2018.
2. Go to one of the reports, say, 2016. Find the Combine Sheets icon in the Merge group under the Ablebits Data tab.
3. On the first step, check all the sheets you need to combine: 2016, 2017, 2018.
4. Select the columns to combine: Customer and 2016, 2017, 2018.
5. Step 3: Select additional options or simply click Next.
6. Select the place to locate your combined data.
As a result, you will get a new worksheet with duplicate customers in the first column and data from your reports on different lines in the second, third, and fourth columns.
To get the sales data combined by the names of your customers, use the Merge Duplicates tool:
1. Select your new table and run Merge Duplicates, you can find its icon right near Combine Sheets in the same Merge group.
2. On step 2, choose only one key column with duplicate records: Customer.
3. On step 3, check columns 2016, 2017, 2018 and click the Finish button.
Thus, you will get one sheet with the list of customers and their sales by years 2016, 2017, 2018.