Forum Discussion
Aligning Multiple Name Lists
ThomasEinolf That would be a piece of cake for Power Query (PQ), provided that the names in both data sets are spelled exactly the same. I noted that some names had a trailing space and other did not. Then, you need to create som extra steps in PQ.
Connect to both lists, do some cleaning up. Then merged the two (full outer).
See attached, in columns O:R. If you are not familiar with PQ, here's a good start:
ThomasEinolf That would be a piece of cake for Power Query (PQ), provided that the names in both data sets are spelled exactly the same. I noted that some names had a trailing space and other did not. Then, you need to create som extra steps in PQ.
Connect to both lists, do some cleaning up. Then merged the two (full outer).
See attached, in columns O:R. If you are not familiar with PQ, here's a good start:
- Thank you! I am currently trying this example, and when I am going to merge the two, did you click that the values were both in common or the names? I am getting stuck on merging them together.
ThomasEinolf Not sure what you mean, but you need to trim the names first to get rid of the trailing spaces. Then you merge the two tables by the Name columns, full outer. Then expand the mergered records.
- Amazing! Worked perfectly! Thank you!
