Let's say I have a scenario where I have 20 payees. I have to record 4 payments to them every month. i.e. every month 80 entries - which will be pretty much the same. Is there a way in Power Query to quickly enter this data. I've attached a file with sample data. At the moment I have created a sheet with dropdown entries and vlookups to pull in the matching amounts etc but apparently "this is too much work" so I'm looking to Power Query to see if there is a way around this...thanks.
Hi Anne,
I see it as a simple merge, the trick is to add to both tables a custom column with the same number in all rows (the custom column formula is: =1, instead of 1 can be any number, as long as you use the same number in both table queries)
This custom column will be the key for merging the tables, see the attached file.
Ah, excellent. Worked through it myself and it worked a dream...the custom column and expanding the table was the bit I was missing...thank you 🙂 Knew PQ would have a solution for me!
You're welcome 🙂
