I wanna create a sheet with multiple columns of data... I would like to put sort options on the header columns.. so if one of the column is named PLAYERS NAME and then another Header is named AT BATS and then another header is named HITS, I want the viewer to sort any column he wants just by clicking the header either in ascending order or descending order. So if he wants to see who has the most hits, the the viewer should click on Hits and have it go from ascending or descending order. If he then wants to click on Players name it should sort the same way for that column and keep its data in the correct row. How can I achieve this?
edit: This must work in View Mode