Copying Sorted Data in Excel

Hi NaomiHalle,

Thank you for posting your query in our community.

Based on your description, you want to combine lists of sorted data in Excel. I tested on my side, and below picture is my result:(Number column and Price column have been sorted)

I combined data with the Ampersand symbol (&), you can also try it out.

If my understanding is wrong, please feel free to post back and correct me with more details.

Best regards,

Jazlyn

Hi Jazlyn,

Thanks for your response.

Perhaps the use of the word combine was a little confusing.

What I would like to do is unify various lists from Excel into one list.

Being that they are sorted, I cannot do this at the moment.

Thank you

Hi,

Use the Append feature of the Query Editor to create s single list from many lists.

Hi NaomiHalle,

Thank you for the reply.

You mentioned that "Being that they are sorted, I cannot do this at the moment", however, based on our experience and test, sorting the list will not prevent from combining these lists. So, it's quiet strange why you couldn't combine lists.

To help you better, could you please provide some information for me?

1. When you try to combine these lists, did you receive any error message?
2. Please provide one or two screenshots of the lists for us.
3. If possible, you could also provide a sample file via OneDrive link so that we can also investigate it for you.

Best regards,

Jazlyn