You can transpose rows and columns in a selected range. Copy the range, select a single cell, choose Paste Special from the ...