Sort function not working on appended data

[Jaimee001]

Hi Team,
I'm not sure if you can help. I tried to mock up a report and couldn't get it not to work.

I get a report with about 30 columns and 1000 rows with the cells already color formatted.
To this report, I use Vlookups to append data from other data sources.
Once the v-lookup is done, I do a copy/paste special/values. I confirm that the data is valid.

Then I'm supposed to sort everything, including the appended data.
For some reason, the data that's appended, doesn't sort with the rest of the report. It stays exactly the way it came in.

I hope this makes sense.

Regards,
Jaimee

 

[alacrity59]

Is the data contagious once you bring it in? I.e., no blank rows?

When you click on the Sort icon is all the data you want to sort highlighted? Scroll down to see if your new data is included.

 

[Deepak]

Is any blank line there.
Can we have the sample pls.