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.
The best I could have found for Unpivot.
Very clear and concise explanations. Thanks for showing us the techniques.
Glad it was helpful! 😁
Amazing Idea! You are a genius.
Great video! Love the trick with multiple headers. Thank you!
Thanks Trevor, I’m glad you found it useful.
Brilliantly explained... thanks Mark.
Thanks Azeem - I'm glad you found it useful.
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.
Thank you so much Mark, for sharing such an amazing power query video.
You're welcome, I'm glad you found it useful.
Superb video Mark. Thank you for these complete explanation.
Thanks Ivan.
Très pratique, Grand Merci.
De rien. 😁
Great video. Thank you!
Glad you liked it!
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. 😀
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.
Excellent! another good things is it has a sample file to practice with. Many Thanks! Got a new sub here.
Thank you. It is a great help to understand complex data cleaning situations.
Thank you, I'm glad it was helpful.
Marvelous 3rd method
Thank you! Cheers!
Thanks. Greetings from South Africa.
You’re welcome.
Wonderful 😊 Thanks for sharing 🤗
My pleasure 😊
What a master! Thanks a lot :)
Thanks. Glad you liked it! 😁
Thanks
10//10 Great Video !
10/10 - i'll take that 😂
sir you did a great job.....................iiNFLUENCER
Thank you 😀
Thanks ❤
You're welcome 😊
thanks for sharing
My pleasure - Thanks for watching Frank.
Highly appreciated.
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.
Great solution the 3rd case.
Thanks Ivan, I’m glad you found it useful.
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.
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.