Solution for Power BI direct query for Merging columns.

shavish Hey,
I will recommend write something like below 

SELECT
CONCAT(Employer, ' - ', Category) AS Employer_Category,
Name,
ID,
Address
FROM
your_table
ORDER BY
Employer, Category;

then you update this here in Power query

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query