Excel doesn’t offer true tables, which are often ideal for complex data structures with interconnected entities. At times, you will often end up duplicating data across different spreadsheets.

Whatever the reason, you can merge data from one Excel spreadsheet to another using Excel's Consolidate Data wizard. If you have only a few spreadsheets to combine, and the column headers and ...

Excel’s Data Model creates a relationship between two (or more) sets of data using a common field. In this case, the common field is Shelf Code, as shown in Figure A.

See the screenshot below of the Excel spreadsheet after using Data Table for this example. I do not like one thing about this display — the reference in B9. I feel like it is confusing to a user ...