How to rotate Excel worksheet data – Transposing Data
Sometimes our Excel data needs to be rotated or transposed while performing analysis as when we wish to do a Hlookup. We need not rewrite our original data. Select the data, copy it and then paste it by selecting the transpose feature.
Excel TRANSPOSE Function