I assume in columns P#, C#, and T# are stored some values?

My advice is to use the structure like
EmpNo, EmpName; WhateverDataID, Value
where WhateverDataID contains e.g. P#, C#, or T#, and in Vlaue column is the value for this WhateverDataID.

This allows you to group easily your data in any way you want.

And when you like your current setup when looking at your data, simply create a report sheet, which reads data from entry sheet, and displays it in any format you like.