Problem sorting with pasted data

Copper Contributor
Hello
I have copy and pasted a list from a website and some colomns have 2 or 3 cells instead of 1 and because of that the sorting is impossible.
How can I fix the table?
1 Reply

@Excel705 

Perhaps you may illustrate by the sample?