merged column returns value in ascending order

Hi,

Thanks fot watkinnc's concern about the problem and i want to offer some more information for user to refet to.

hello Anonymous ,  based on the picture you have offered,  is the data type of your result column number? you can try to change the data type of the result column to number, then combine it to the table 1.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

after merging initially use Text.Split to split text into several text and then use list.sort to sort them and use Text.combine to convert the list to text