Learning: How to transpose rows and columns in Excel

In the process of data processing today, it is difficult to take the sheet column in Excel into a header.

1. Open the workbook in Excel and select the columns for column and column conversion in sheet. I have 75 rows.

2. Click copy ".

3. Find the cell in the upper-left corner of the table to store the transpose table area and select 75 columns.

4. select edit, select paste, and select the transpose check box.

If a single row is inverted, the number of cells does not match.

Learn practical skills Series

Learning: How to transpose rows and columns in Excel

Good learning: VSS use fault and solution (2)

Learning: Learning magicajax (1)

Good study: Daily English for foreign companies

Learning: Set the dropdownlist value in JS

Fighting against windows: Why is the machine slowing down (1 )?

GDI + screen program

Learning English: Garfield's classic quotations