How to turn a series into a horizontal column in Excel? (The amount of data is relatively large)

This question is still complicated, remember to give more points! !

Now suppose your data is in columns A and B, starting from the first row.

Now, enter the data with the initial serial number of 1 in C 1, D 1, etc. That is, first enter "1 A B C" manually in your example.

Enter the formula in cell C2:

=IF($A2=$A 1，""，A2)

Drag down to the end of the data.

Enter the formula for D2:

=IF($A2=$A 1，""，IF(ISERR(INDIRECT(" b " & amp； IF (indirect ("a" & ROW()+COLUMN(A2)- 1) = $ a2, row ()+column (a2)-1,""), "",indirect ("b"&; IF (indirect ("a"& ROW()+COLUMN(A2)- 1) = $ A2, row ()+column (A2)-1,""))

Drag to the right (be careful to drag to the right until there are enough columns to ensure that the cells behind each row of data cannot drag data), and then drag down to the bottom of the data.

Zhejiang senior high school entrance examination time

Is Zhejiang Mathematics College Entrance Examination Difficult?

Three Branches of Imperial College London Finance Major in London and Its Curriculum

Math group

Where can I buy the first grade mathematics of Lin Xue Beijing Normal University?

20 13 Jiangsu province counterpart single recruit mathematics examination scope?

What is the difference between GRE and GMAT? What's the difference between words?

Water is not water.

Baoding yimo mathematics junior high school

How to remedy the poor math in junior high school