Hi Aye,

See session 7.08 Add Rows. You can use the List.Number function as described here to generate a list of the facility numbers. 

I hope that points you in the right direction.

Mynda

Many thanks, Mynda.

Regards,

Aye

Hi Mynda,

Can I expand with my own list instead of system generated list.

as attached, I made a list for facility numbers. I would like to expand my accounts according to facility numbers. as expected result.

how can I combine the two (Account table and Facility list) in power query.

Thank you.

Regards,

Aye

Yes, just as you would for a list you generate. I see you already converted the Facility table to a list, so now in the Account query add a custom column with the following formula:

=#"Facility"

Then expand the List to Rows.

Mynda

Many thanks, Mynda.

This is perfect and so easy 🙂

Regards,

Aye