I am using Power Query to update a table on the Sheet AllData via an API. I have a separate table on a sheet named Totals with a table tblTotals which has a Total Row. Before my Query refreshes my data, I want to grab my some of the values from the tblTotals Total Row and add it to a third sheet/Table with a timestamp column to log the history. I want this new table to update not overwrite the data. Can this be done with PQ? Can it be done by editing my existing PQ? if so how? I have little to no experience wit PQ but know the mechanics.
Thanks!
Thanks!