I’ve searched for related questions but non seem to have the same use case I’m trying to solve for. Please forgive the duplication if any.
After many hours of Googling and watching YouTube I know this can be done but I can’t get it to work. Any advice would be great.
Please note. I'm using Excel for Mac.
What is my data?
I've got several named tables across many sheets that relate to design tokens. All tables are two columns with the same table header row.
Example data
Global font tokens:
Table name: tokens_global_font
| Token | Default value |
|---|---|
| $cds-global-font-stack | 'Roboto', Arial, Helvetica,sans-serif; |
| $cds-global-font-stack-decorative | 'Roboto', Arial, Helvetica,sans-serif; |
| $cds-global-font-size | 16px |
Global Colour tokens:
Table name: tokens_global_colour
| Token | Default value |
|---|---|
| $cds-global-color-chameleon_green-50 | hsl(184, 32%, 93%) |
| $cds-global-color-chameleon_green-100 | hsl(184, 32%, 86%) |
| $cds-global-color-chameleon_green-150 | hsl(184, 32%, 78%) |
What am I'm trying to do?
I need to create a master table that will consolidate all tables into one. This table needs to be dynamic so if data is added to any of the source tables it’s also added to the master. If any values change, then they are propagated.
What have I tried?
The consolidate feature which doesn’t seem to do anything. I get “Alert no data was consolidated” after I add my tables.
I’ve also tried using Power Query. But what this does is create additional sheets with the same data in separate tables.
With both of these methods I’m probably doing something wrong but this is the most advanced thing I’ve ever tried to do in Excel so consider me a novice.
CodePudding user response：
You can do it with the Filterxml function.
CodePudding user response：
With Power Query it is also possible:
Make a query from each table:
combine all the queries.
(Append as new)
