Forum Discussion
Search Multiple Columns all at once to Find, Locate and return Matching Data Details (Power Query)?
Help please! What is the best, quickest and simplest method? I have a column of [default emails] on one Worksheet1; And three(3) different columns of [email_1], [email_2] and [email_3] on a dif...
Power Query could be as attached - unpivot all columns with emails in second sheet and inner join with first one to have only matched emails.
As for PivotTable I didn't catch what exactly would you like to have.