Forum Discussion
Need Help with Excel Spreadsheet
I am trying to find client names (Column B) that are associated with the same jobs numbers that are column C and paste all the names in a new column. For Example: Jon Doe - B20-999A Jim Doe - B1...
A solution could be Power Query. In the attached file you can enter data in the dynamic table in columns A and B. Then you can click in any cell of the green table and right-click with the mouse. Then you can select refresh to update the query.
- Thank you. Is there a way you can convert the Query Text to English just in case I have to edit something please.
You are welcome. I've translated the query steps into english. Everything else should translate into your language when you open the Power Query Editor.
