I have two tables in a worksheet that are tied to separate queries in Power Query and are "stacked" vertically ("Table A" starts in B1 and "Table B" starts in D1). Upon a data refresh, if "Table A" returns more rows of data, "Table B" is successfully pushed down the sheet. On successive refreshes, if "Table A" returns fewer rows of data, "Table B" is successfully moved up the sheet (so far, so good).
I'd like to give both tables a title in the cell above the table. Using the above example, A1 could include a title "This is table A", and C1 could include a title "This is table B". When I simply add those static cells in my sheet, the data refreshes no longer move "Table B" up or down the sheet. I instead get the "this won't work because it would move cells in a table on your worksheet" error. I'm assuming by adding that static data in my worksheet, Excel no longer knows how to handle it relative to my growing/shrinking tables.
Is there a way to format my tables to include a Title row above the Header row so that the title simply becomes part of the table itself?
Is there a better way of accomplishing what I'm after?
Thanks in advance!
I'd like to give both tables a title in the cell above the table. Using the above example, A1 could include a title "This is table A", and C1 could include a title "This is table B". When I simply add those static cells in my sheet, the data refreshes no longer move "Table B" up or down the sheet. I instead get the "this won't work because it would move cells in a table on your worksheet" error. I'm assuming by adding that static data in my worksheet, Excel no longer knows how to handle it relative to my growing/shrinking tables.
Is there a way to format my tables to include a Title row above the Header row so that the title simply becomes part of the table itself?
Is there a better way of accomplishing what I'm after?
Thanks in advance!
