Hi there,

I have a sheet that I would like to have transposed on the second sheet. I found the formula:
{=(Transpose(A1:H11))}
Which uses an array, however is there a way to do this that keeps the formatting, as the data in this matrix is either a green fill or a red fill no values as such?

I wasn't sure which forum to post this in, but either formula (which would be preferable for ease of use) or VBA is fine.

Kind regards

Rob