Normally, you would flatten the data by using VLOOKUP to pull data from the orange and yellow tables in to the blue table. You could combine three data sets using INDEX and MATCH Region and Sector are not in the original data, but you have lookup tables to provide this information. You need to combine certain markets into regions. There are fields for customer and market. department gives you the data set shown in columns A:D. Today, Ash's favorite feature is joining multiple data sets using Relationships and the Data Model. His team brings you pivot tables and many other good things. Ash is a product manager on the Excel team. Today, our tip from Ash is joining tables in a pivot table.Įvery Wednesday for seven weeks, I am featuring one of the favorite tips from Ash Sharma. Most of Power Pivot is built in to Excel 2013 and even more in Excel 2016.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |