Using chart to display data in multiple columns

Ask for Help
1

I am trying to display the percent of bacteria that are killed by a specific antibiotic in a specific hospital system. This data is specific to each bacteria, antibiotic, and system. I have tried entering the data as below but not sure if this is the best way.

Trying to have it so user can arrange by a specific hospital or choose a specific bacteria to display the susceptibility number. They could either see the data at a specific hospital or an entire region e.g. the midwest. any ideas?

Link to file

2

Are you specifically talking about data up to row 53 only?

3

No this is just a sample. This will potentially have hundreds of rows. Ignore the array setup at the bottom. I was just testing something.