![]() No, you would need to add this as a manual column.Ĭould you please give a recap of the XLOOKUP function? Is the consolidation able to reference the names of the tabs Mon, Tue, Wed? ![]() ![]() See our other webinars on PQ for more details. Secondly, you could add each dataset to the data model using Power Query (Data => From Sheet), and then create a new query that appends all of these into one. However this is a very manual process and won’t update if the source data is updated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |