Than you for the great video. I think I've seen ech one of those examples in real life so it was very helpful seeing you transform the with Power Query.
For those curious. the photo in the background is Frank Sinatra in the "spotlight" taken by Phil Stern at the JFK Inaugural Ball Rehearsal, Washington DC, 1961.”
That's really interesting. Obviously, I knew it was Frank Sinatra, but I had no idea where or when it was taken. There is just something about the lighting/shadows that I really like.
What is the work around if you return data to a table back into Excel, but then want to do all sorts of calculations with it not being in a table? Do you copy and paste value to another sheet??? But then you will have to do it every time you update. The issue is if you return it as a table and then in the returned table add new columns with data. (for example now you add a new column for a region.
I can’t visualise the situation you are describing. Never copy and paste, it loses all the benefit gained. If you add a new column to the Table you will need to update your formulas to account for the new categorisation anyway.
@@ExcelOffTheGrid I assume it would be best to add for ex a Region / Outlet / Country column in the original data. What if you want to use Subtotals with Data Subtotals option to the new table. Will you first have to remove subtotals, refresh and run Subtotals again?
@@ExcelWithChris Tables hold data in a structured format. We then use formulas or PivotTables to calculate on the Table to create the presentational format. If you try to use a Table for presentation as I think you are suggesting, you are using the wrong tool for the job.