Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transforming single row into multiple row

I have a large table of data as below,  refrence no. booking name Booking type start date duration end date venue pax ab12345 booking 1 a 23/03/2020 2 25...
Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi! yes you can do that. Go to edit queries. Then add a custom column with a code like this:

    List.Transform({Number.From([start date])..Number.From([end date])}, each Date.From(_))

    This will create a list for each row containing the values between those dates. Then you can expand the list clicking on the arrows button. The result will be the expected one.

     

    Regards,

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
6 years ago

Hi! yes you can do that. Go to edit queries. Then add a custom column with a code like this:

List.Transform({Number.From([start date])..Number.From([end date])}, each Date.From(_))

This will create a list for each row containing the values between those dates. Then you can expand the list clicking on the arrows button. The result will be the expected one.

 

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.