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.
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.
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.
The best I could have found for Unpivot.
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.
Highly appreciated.
Great video! Love the trick with multiple headers. Thank you!
Thanks Trevor, I’m glad you found it useful.
sir you did a great job.....................iiNFLUENCER
Thank you 😀
Very clear and concise explanations. Thanks for showing us the techniques.
Glad it was helpful! 😁
Great solution the 3rd case.
Thanks Ivan, I’m glad you found it useful.
Thank you so much Mark, for sharing such an amazing power query video.
You're welcome, I'm glad you found it useful.
What a master! Thanks a lot :)
Thanks. Glad you liked it! 😁
10//10 Great Video !
10/10 - i'll take that 😂
Thanks ❤
You're welcome 😊
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.
Thank you. Power Query is the answer. 😀
Thanks. Greetings from South Africa.
You’re welcome.
Great video. I know I can use the techniques you demoed. I'll just have to review the video a few more times. Thank you.
Thanks 😀
If you download the example file from the blog post you can do a bit of practice before trying it on your own data.
Superb video Mark. Thank you for these complete explanation.
Thanks Ivan.
Brilliantly explained... thanks Mark.
Thanks Azeem - I'm glad you found it useful.
thanks for sharing
My pleasure - Thanks for watching Frank.
Marvelous 3rd method
Thank you! Cheers!
Thank you. It is a great help to understand complex data cleaning situations.
Thank you, I'm glad it was helpful.
Excellent! another good things is it has a sample file to practice with. Many Thanks! Got a new sub here.
Instead of click on the columns header to rename Attributes to Month, you can go to m-code and make the change there.
It will give you one step less.
Very true.
I also would remove the auto applied steps. But I got to try and start where the viewer is likely to be.
Très intéressant
Serais contente de suivre vos cours
J'ai un programme de formation sur exceloffthegrid.com/academy, auquel vous êtes invités à vous joindre.
Great video. Thank you!
Glad you liked it!
Très pratique, Grand Merci.
De rien. 😁
Wonderful 😊 Thanks for sharing 🤗
My pleasure 😊
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.