Forum Discussion
Solved
Combine data and number column in Power Query
Hello, I need to some help, I think it should be fairly simple but for the life of me I can't find the solution. I have some not so great data which I need to find the duplicates, to do that I ne...
FYI that you can Ctrl click on your number and date columns to select them both, and then choose Remove Duplicates from the ribbon under Remove Rows. To concatenate them, they both need to be type text, so you'll need something like:
= Number.ToText([Number Column]) & " " & Date.ToText([Date Column], "yyyyMMMdd")
Pat
FYI that you can Ctrl click on your number and date columns to select them both, and then choose Remove Duplicates from the ribbon under Remove Rows. To concatenate them, they both need to be type text, so you'll need something like:
= Number.ToText([Number Column]) & " " & Date.ToText([Date Column], "yyyyMMMdd")
Pat