Hi there,
I have a sheet that I would like to have transposed on the second sheet. I found the formula:
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?{=(Transpose(A1:H11))}
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
Bookmarks