Forum Discussion
Solved
Consolidation Table from Different Excel Tabs with Different Format
Hi all! I have 5 (source) tabs with tables with data but in different formats. They all have common data but column headers are named differently. I want to have a separate tab (consolidation) that ...
- Almost certainly this is possible.
One solution may be to use Power Query to add the tables to the data model, link the appropriate columns and then create an output table.
Another option is to use Dynamic Array formulas to combine all the information
A third and possible best option is to create a master table with all the data and then have those other 5 tables actually pulled out from the master table based on some criteria (either with pivot table or DA formulas).
It is hard to know more of the details without a sample file.
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Microsoft Excel space - please post Excel questions here in the future.
Thank you, Eric. Will do.