I am trying to use Power Query to merge data. Something so minor is driving me nuts; I cannot figure it out. First, my merge is creating duplicates, which, I have an idea what's going on there. However, where I am perplexed is, I'm trying to merge data onto a layout that cannot change. For example, using the baseball terms I am using, if I have the following:
3B
OF
OF
OF
If I have a 3B, I want that player placed at 3B. If I have one OF, I want that player placed at OF. However, I need the other two "OF" to show as blank. I'm not able to do this. I know none of this makes sense but I've uploaded a file that I hope helps. I think it's an easy answer but after several hours, I've given up. This was referred to seek help.
Hi and welcome to our forum!
Thanks for sharing your file, however I couldn't see an example of your desired result, so I'm not sure what you're trying to achieve exactly, but I'll take a stab at it.
At the moment your merge is doing the equivalent of a VLOOKUP, so it's going to find a match between OF in Position and Shippensburg. If there's no match you'll get a blank, but any matches will be filled. If you want to differentiate between 3 OF records then you need to give them unique identifiers e.g. OF1, OF2, OF3 etc.
In the attached file I've used the technique described here to group and number records. Then I've appended the numbers to the Pos to return a distinct list of Positions.
I hope that's what you were after, but if not, please provide a sample Excel file showing your desired result.
Mynda
Your "output" is exactly what I was trying to do. I could not figure out the "grouping" as you mentioned. I want to take a longer look at your file and go through each step, re-creating myself. Thank you very much.
