Forum Discussion
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. ...
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.