Now when we combine the data from all regions into a master sheet, the data got mixed up. This would typically done using Pivot Table / PowerPivot or Power View AFTER the data is combined. Please note that we are not interested in performing any summary calculation. Now what is expected? Most people just want to combine all the data across sheets into a final sheet which contains all 40 rows. Please read these two articles for consolidating cross-tab data.Ĭrosstab data consolidation using Power Query This article does not cover cross-tab data. Usually it is month, region, location, person, product, etc. Each sheet represents some property or source.Each sheet contains the same columns in the same order.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |