Forum Discussion
Combining 2 columns of names into one and matching other column info
Hello All, I have power automate triggering tasks and filling in a spreadsheet when certain emails come through. It's basically to track actions with strict timeframes. Power automate can fil...
Davidm54 Since you are already using Power Query, you can unpivot the two name columns and perform a few clean-up steps. Example attached.
Thanks for this. I should mention that I generally share from my private account/365 account and my work Office is sometimes a different version. I may have just missed the pivot options, but I'll definitely check it out. Certainly the cleanest way.
Appreciate all who have given formulas as well.
Appreciate all who have given formulas as well.