Forum Discussion
Joel Henson
Jun 18, 2018Copper Contributor
Combine data from multiple sheets into one sheet
Hi. So I have a workbook with multiple sheets. Each sheet has multiple columns of information. I am trying to get multiple columns from multiple sheets combined into one column on a "summary" sheet. For example, each sheet has data in column A. I would like all of the data from column A of each sheet to populate into column A on my "summary" sheet. How can I make this happen?
- JamilBronze Contributor
You have two easy options.
If you Excel 2010 or above, you can use power query aka Get and Transform.
If you have excel lower than 2010 then you can use the Microsoft Excel Free Add-in RDBMerge, Excel Merge Add-in for Excel for Window it is very easy to use.