Consolidating columns excel 2016
The following video shows the Query Editor window appearing after editing a query from an Excel workbook.To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet.
Merging into one cell will keep the upper-left most data only." (Excel 2010, 2007) Further in this article, you will find 3 ways that will let you merge data from several columns into one without losing data, and without using VBA macro.
Though, it required quite a lot of effort and time :( This way is faster than the previous one, it doesn't require formulas, but it is suitable only for combining adjacent columns and using the same delimiter for all of them.