excel transpose column to row

Here’s how: Select the range of data you want to rearrange, including any row or column labels, and either select Copy on the Home tab, or press CONTROL+C. back to gemscool login Note: Make sure you copy the data to do this Using the Cut command or CONTROL+X won’t work Select the first cell where you want to paste the data, and on the Home tab, click the arrow