How do you split a table up into multiple smaller tables by column?

[born2dive00]

Hello all
Ok this should be simple but be danged if I can figure it out.
when you have a regular table and have data in mutiple collumns and hit sort it sorts the whole table.

BUT how do I break that table up by columns so i can sort each column independently of the rest, in essence break up a large table into smaller tables by columns so when I sort, it sorts only that column

please see attached excel example

Please let me know and thank you all

[AliGW]

Are you still using Excel 2007?

[born2dive00]

No, Ive reluctantly updated to office 2019 laptop edition. lol, thanks for pointing that out, Ive edited it on the profile.

[AliGW]

What a shame! You should have future-proofed yourself and gone with 365.

You have already done the only thing you can do by splitting each column off into its own table. If this needs doing to multiple tables, then you may need to request a macro to do the job for you, as there is no other way.