Hi Team,
I would like to expand particular GL accounts by cost center as attached.
Please see expected result for reference and please help me doing that in Powerquery.
thank you.
Regards,
Aye
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