Forum Discussion
Combining two columns with a / between them in Power Query
How would I take the two circled columns and combine them in Power Query with a / between them? I need PageReferrer.1.2 before pagePathPlusQueryString. This data comes directly from GA4, so Power Query is the best place to combine the two.
AlliedSol_Liz
in Power Query, click on PageReferrer.1.2 press CTRL and click on pagePathPlusQueryString. under Transform tab, click Merge Column, choose as follows, provide a desired name:
3 Replies
AlliedSol_Liz
in Power Query, click on PageReferrer.1.2 press CTRL and click on pagePathPlusQueryString. under Transform tab, click Merge Column, choose as follows, provide a desired name:Thank you Fowmy! That solution worked great!
Hi AlliedSol_Liz,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you want to merge two column with a '/' separator between them. Please go through the solution provided by Fowmy. If it solves your issue, please accept it as solution.
I would also take a moment to thank Fowmy, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
