Forum Discussion
Need Help With Automating Names From One Table To Another If Certain Aspects Match
Good morning all! I'm in need of help with this scenario: I need to have a formula that copies the name in the first table to the 2nd table if the project name matches. I currently ha...
Not sure this does exactly what you expect as I don't understand what you mean with "if the project name matches" + why your output shows Phase2 only for the various projects:
With Power Query: Unpivot columns PM, AsstPM...CM5
- Thanks for the response! So it's matching the project names in the "Name" column of the first table, and the "Project" column in the second table, then extracting the "person" assigned in the PM, APM, MAPA, and CM 1 - 5 columns in the first table to the "Assigned" column in the second table. Hopefully this clarifies my goal.
- I just learned my company now has PowerQuery in Excel. We previously only had PQ in PBI, but now that we have it in Excel, I can achieve this the way you mentioned. Thank you so much!
