Filter messing up all data (?)

[Camel123]

Hi,

Only when sorting numbers in ascending or descending order all row information get's messed up and disconnected from where it actually belongs. Due to this wrong data is presented under all project numbers. When clearing the filter, it does not return to the correct project number. I have to use ctrl+z to return all rows information correctly.

How to solve this mess?

 

[sandy666]

change your range to Excel Table (Ctrl+T) then try again