TRANSPOSE with COUNTA

[mcorydon]

Hello All, For some reason Excel will not allow the user to transpose an entire sheet, Is there a way to write a formula that will figure out the exact dimensions of the data table regardless of size and transpose it? I've done something like this with HLOOKUP but cannot find a way to do this with TRANSPOSE Thanks