Posts Tagged 'Merge data in Excel'

How to unmerge cells in Excel

When you have related data in several cells, you may be tempted to combine them into a single cell for alignment or comparison purposes. So, you merge a few smaller cells into a bigger one only to realize that merged cells have made it difficult to perform the simplest tasks on your worksheet. How do you unmerge cells in Excel to get things back to normal? Continue reading

Excel IFERROR with VLOOKUP - elegant way to trap errors

Excel VLOOKUP and IFERROR - these two functions may be pretty hard to understand separately, let alone when they are combined. In this article, you will find a few easy-to-follow examples that address common uses and clearly illustrate the formula logic. Continue reading

VLOOKUP with IF statement in Excel

Whilst VLOOKUP and IF functions are useful on their own, together they deliver even more valuable experiences. Today, we will be looking at a few simple examples that will show you how to Vlookup with If condition in Excel. Continue reading

How to merge multiple Excel files into one

Merging multiple Excel workbooks into one file could be a cumbersome and long process. So, which is the best way to handle the problem: copy the sheet tabs, run VBA code or use a special tool? Continue reading

Video: 6 ways to merge Excel sheets with 1 add-in

Combining data from multiple sheets becomes effortless if you have Consolidate Worksheets Wizard for Excel. See all the ways this add-in lets you copy, consolidate, and merge data from your tables. Continue reading

Lookup in Excel: functions and formula examples

Looking up a specific value within a dataset is one of the most common tasks in Excel. And yet, there exists no "universal" lookup formula suited for all situations. In this tutorial, you will find an overview of the most popular Excel Lookup functions with formula examples and in-depth tutorials linked for your reference. Continue reading

How to Vlookup to return multiple matches in Excel

When using Microsoft Excel for data analysis, you may often find yourself in situations when you need to get all matches based on a specific id, name, email address or some other unique identifier. An immediate solution that comes to mind is using the Excel VLOOKUP function, but the problem is that it can only return a single match. Continue reading

Video: How to merge duplicate cells in Excel

Learn different ways you can combine unique values or sum numbers that refer to the same record in Excel Continue reading

How to concatenate text in Excel 2016 using the TEXTJOIN and CONCAT functions

Learn about two Excel techniques to concatenate strings using the brand new TEXTJOIN and CONCAT functions. Continue reading

Video: how to merge and combine rows in Excel

This video will show four different solutions for merging rows of data, blocks of rows, or duplicate records from different lines in your table. Learn what formulas and tools you can use to combine rows in Excel and keep all important information intact. Continue reading

Video: Three ways to merge columns in Excel without losing any data

We often need to combine columns in Excel to get names, addresses, and similar records in one cell. As there are no built-in tools for merging values from multiple columns, see three ways you can go in this video. Continue reading

Video: Merge two Excel sheets in 6 simple steps

We have introduced some exciting changes to one of our best time-savers. This video will show you how Merge Tables Wizard can quickly and efficiently combine data from two Excel files. No formulas, no redundant work, just 6 simple steps to get the job done. Continue reading

Consolidate data in Excel and merge multiple sheets into one worksheet

The tutorial demonstrates different ways to combine sheets in Excel depending on what result you are after – consolidate data from multiple worksheets, combine several sheets by copying their data, or merge two Excel spreadsheets into one by the key column. Continue reading

How to merge cells in Excel without losing data

The tutorial demonstrates different techniques to quickly merge two cells in Excel and combine multiple cells without losing data in Excel 2016, 2013, 2010 and lower. Continue reading

CONCATENATE in Excel: combine text strings, cells and columns

In this tutorial, you will learn various ways to concatenate text strings, cells, ranges, columns and rows in Excel using the CONCATENATE function and "&" operator. Continue reading

Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors

The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel, troubleshoot and fix common errors and overcome VLOOKUP's limitations. Continue reading

INDEX & MATCH in Excel - a better alternative to VLOOKUP

This tutorial demonstrates the key strengths of Excel's INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples that will help you easily cope with many complex tasks when VLOOKUP fails. Continue reading

How to use VLOOKUP & SUM or SUMIF functions in Excel

In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Continue reading

Excel VLOOKUP tutorial for beginners with formula examples

This VLOOKUP tutorial explains the syntax and provides a number of examples that illustrate the most common usages of the VLOOKUP function in Excel. Continue reading

How to create labels from Excel using Mail Merge

This tutorial explains how to mail merge and print labels from Excel 2010 and 2013. You will learn how to properly prepare your Excel file to make mailing labels, set up the main label document in Word and save it for later usage. Continue reading

How to mail merge from Excel to Word

Mail Merge from Excel to Word can be a real time-saver when it comes to sending large mailings. This tutorial provides an overview of the main features and explains how to do a mail merge from Excel to Word step-by-step. Continue reading

How to merge rows in Excel without losing data

This article provides solutions for 4 different scenarios of merging rows in Excel. See how you can quickly merge multiple rows without losing data; how to combine duplicate Excel rows, how to repeatedly merge blocks of rows, and how to consolidate matching rows from two different spreadsheets. Continue reading

How to merge two columns in Excel without losing data

From this short article you will learn how to merge multiple Excel columns into one without losing data. Continue reading

Combine Excel worksheets of the same name into one spreadsheet

This article describes 3 possible ways to merge the same name worksheets across multiple workbooks into a single Excel sheet, and explains how to choose the solution that best meets your needs. Continue reading

How to merge two Excel Worksheets by partial cell match

This article will show you how to quickly merge data from two Excel tables when there are no exact matches in your key columns, e.g. your unique ID in the first table may make up the first five characters of the ID column in your second table. I have tested all the solutions I present in this article, they work in Excel 2016-2007. Continue reading

Video how to: consolidate duplicate rows keeping unique data only

Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading

Update Data in Excel with Merge Tables Wizard

There are some tasks in Excel that take so long to do and which are so tedious that you wonder why there isn't an automated way to do them. One task that falls into this category is that of updating a table with data stored in another table. You either need to spend a lot of time and exercise a lot of patience and care to perform the task manually or hand it over to the experts in the form of the Merge Tables Wizard from AbleBits. Continue reading

Applying multiple Subtotals to your Excel table

Using Subtotals is much more flexible than I put in my previous post about it. Here I would like to expand – literally - the Subtotal function to show some other options that might help you do the work ... Continue reading

How to Consolidate Data in Excel 2013 - 2003

There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters, you can create PivotTables, or you can consolidate large amounts of data into a summary form. In this post I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets – or workbooks – and summarize them into a single worksheet. Continue reading

Merge all your Students' Data into a single Excel File

School has begun again as hot summer days gave way to classrooms full of students. With tighter budgets we are facing classrooms with more students and less time for getting to know them. With all the data scattered in different reports, let me show you how quickly you can create a single Excel data binder using Merge Tables Wizard… Continue reading

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite 2018.4 for Excel
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard