Split Master sheet Into Multiple sheets Using Power Query

[@shafeek802]

What if there are 100 such cities? Is there any easy way of power query automatically detecting the city and splitting automatically.

[@AaronBruffett]

I have been looking for this video for a while. Every time I sure "Split into multiple worksheets Power Query" it shows me how to GET dates from multiple sheets and load them into one. Thank you so much for this Video!

[@Chokhmah_Learning]

Glad it helped!

[@27oslec]

If there is update in master sheet, will it be updated in individual sheet?

[@Prafful000]

When there are changes/updates made in the individual city wise sheet. How do I consolidated the updated data into a master sheet again? Please advise

[@nawafaldawsari8706]

You made my day.
Many thanks bro
🌷🌷🌷🌷🌷🌷🌷🌷🌷

[@Chokhmah_Learning]

My pleasure

[@torque6389]

Helpful, thank you!

[@JJ-ld4cc]

Thanks brother

[@QUIZN-fh6tv]

Thanks