How do I sort multiple columns of numbers in ascending order in the Numbers app on iPadOS?

IPADOS 26....Numbers app...I have 3 columns of numbers...I want to sort each column ascending...I sort column 1 just fine...I sort column 2 and column 1 reverts to its original order....i sort column 3 and column 2 reverts to its original order....what the heck is going on and how do I sort all 3 columns?

[Re-Titled by Moderator]