Awesome Power Query example - Calendar data to table format 📅➡📄

Got some calendar format data? You can use either formulas or Power Query in Excel to quickly convert that to a table format. In this video, I will demonstrate how to use Power Query in Excel to do this.

For sample file, visit

https://chandoo.org/wp/wp-content/uploads/2020/09/calendar-to-table-pq-v1.xlsx

For more on Power Query
https://youtu.be/PiFAa_jjaEI
https://chandoo.org/wp/power-query-tutorial/

For formula based approach on the same
https://chandoo.org/wp/excel-formula-to-convert-calendar-format-to-table/

#PowerQuery #Excel

Видео Awesome Power Query example - Calendar data to table format 📅➡📄 канала Chandoo