I am not quite sure what you mean rotating a worksheet 180 degrees.
Based on my understanding you may want to use a Pivot Table and maybe work
around with the designs and see what turns out? I would like to help you but
I really don understand what you are trying to do.
Thanks