Generate rows between dates

Question

Hi community

I have a table like the top one below which i am trying to convert to match the table below, so there is a row for every date. How would i do this ?

many thanks !

ProductValid FromValid TooCostPlaystation01.01.202205.01.2022£100

ProductDateCostPlaystation01.01.2022£100Playstation02.01.2022£100Playstation03.01.2022£100Playstation04.01.2022£100Playstation05.01.2022£100

ddiesel · Answer

Hi @caldowd1998! Did any of these solutions work for you?

binu_acs · Answer

@caldowd1998 one way of dong this

Generate_Row_15_06.yxmd

DataNath · Answer

One way of doing this with generate rows - If you're not precious about the format of your date being dd.mm.yyyy then you can just remove the formula tool I've added:

Generate rows for date range.yxmd