missing rows pivot table

[jorgeotaegi]

Hi,

I'm trying to group some data that was logged irregularly by a sensor into hourly intervals. I've managed to do so with a pivot table, but then I find the following problem:

Because the data does not contain some of the hours of the day (see pictures), the pivot table does not include them. I would like every day to have the same number of rows (24) from 00:00 to 23:00.

If I arrange the table differently, I can get this (see second picture) but I would really prefer to have it arranged vertically

[#2]

You could do this with Power Query by adding a table which contains all dates, create a relationship between the tables (date table and data table) and then show the date from the date table in your pivot with the option to show rows without values. Are you familiar with power query?