How to unpivot data in excel using power query | day-hour 365x24

Опубликовано: 14 Январь 2025
на канале: Karina Adcock

1,138

Converts numbers into dates and times in power query.
365 days as columns & 24 hours as rows - hourly data for a year
1) Create a table and make a new query
2) Unpivot other columns
3) Custom column to convert days into dates:
Date.AddDays(#date(2019,1,1),[days]-1))
4) Custom column to add dates to hours:
[date] + #duration(0,[hours],0,0)
5) Delete extra columns and Close & Load
---------------------------------------------------------------------------------
#exceltips #exceltutorials #powerquery

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, Beta Channel, Version 2103
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
Power Query: split column by delimiter with multiple spaces    • Power Query: split column by delimite...
How to combine tables with different columns in excel    • How to combine tables with different ...
How to combine tables side by side in excel    • How to combine tables side by side in...