Forum Discussion
Re: Need help with Excel Formula
Riny_van_EekelenGood suggestion. I have added the example in the attached file.
3 Replies
tviss64 Great! I'm on my way out now. Gladly leave it to someone else her to resolve. If not, I'll get back to you later.
Riny_van_EekelenThank you!
tviss64 This is something that would fit Power Query (PQ) very well. Especially if you have to do this regularly and on larger data sets. Created two structured tables from the Original and New data. Queried them and did three merges that load the desired records back to your sheets 3, 4 and 5. See attached workbook.
Are you familiar with PQ? If not, the site in the link below would be a good place to start.
