Automatically populate a 9 box grid using excel data

Hi,

I'd like to automatically populate a 9 box grid using data from Excel. The number of names for each rating can be anything from 1 to 100 so the size of the grid would need to be adjustable. I would like one table for each function and grade. Attached is what I'm trying to do, can anyone help? In the 'example tables' sheet, I've shown how I'd like the tables to look, but with my live data the tables would be bigger so I'd like to do one table per worksheet (or possibly one function per worksheet - so 3 tables).

I hope this makes sense!

Thanks
Chris

Hi,

Please see if you are Ok doing this with the help of a Pivot Table (file attached).

Hi,

Thanks for the reply. I am using pivots at the moment but having to copy the information so it appears in the 9 box grid format.

Thanks
Chris

Sorry I just realised I uploaded my file before I had finished updating it. Please see updated attachment with the tables how I'd like them to be displayed.


Thanks
Chris

In this worksheet, what does the calibration 1-5 column mean?

I am a new uses and not an expert in Excel. I am trying to create a simple HR 9 box. it will be about 400 employees so i want to categorize them by job title , perf and potential

Would love some help with a template that would just allow me to enter the names and populate a 9 box for HR. I am good but not an expert with excel formulas. I have a lot of employees and want to categorize by job title, perf, potential