How to rotate a data Table in Excel 2010? (NOT TRANSPOSE)

Hi,

Could you possibly give a few more examples using grids of different dimensions and rotations through different angles?

From the example you've given, I can see how rotation is defined for squares comprising of an odd number of rows/columns, since in those cases it appears that the central (i.e. geometrically at the origin) entry is unchanged by rotation. However, for squares comprising of an even number of rows/columns, in which cases there is no one entry which could be defined as 'central', how is 'rotation' defined in these cases (with respect to the 'central' entries)?

Perhaps if you could expand your examples to include e.g. a 4x4 and a 5x5, with a few different rotations for each, ideally accompanied with explanations, that would be great.

Regards