When the single column in the figure above turns into multiple rows , You can do that :

1、 Enter... On the first line A2、A3, Drag the first row to the right :

2、 The second line is in the rightmost order of the first line , write down A12, Drag the second line to the right :

3、 Choose these two lines , And then drag out a series of consecutive rows :

4、 Don't unselect the previous step , Use the replacement function , take A Replace with =A:

5、 complete :

Excel skill -- More related articles about changing a single column into multiple rows

  1. MySQL 5.7.16 String splitting -> Single column to multi row records ( forward )

    http://blog.csdn.net/mchdba/article/details/53889803 ----------------------------------------------- ...

  2. Excel skill — Start menu format brush six functions

    turn : Excel skill - Start menu format brush six functions Enjoy it , Develop habits : A journey , Begins with a single step . WeChat search [ Yixin Excel] Pay attention to this different we media person . this paper  GitHub https://github.com ...

  3. Excel How many lines can there be at most

    We usually use Excel How many lines can there be at most ? answer :1048576, As shown in the figure, enter this number in the red box to see .

  4. HNU13028Attacking rooks ( Binary matching , One line becomes many lines , One column becomes many columns )

    Attacking rooks Time Limit: 20000ms, Special Time Limit:50000ms, Memory Limit:65536KB Total submit u ...

  5. hive One line into many lines and many lines into one line

    hive One line into many lines and many lines into one line scene name alias zhaoqiansun abc def ghi When processing data, the above table needs to be processed into the following form : name alias zhaoqiansun ab ...

  6. mysql Transfer line column , Single column to multiple rows

    Transfer line column Use CASE sentence : SELECT SUM(CASE USER_NAME='A' THEN KILLS END) AS 'A', SUM(CASE USERNAME='B' THEN KILL ...

  7. C# Use Epplus export Excel [4]: Merge the specified lines

    C# Use Epplus export Excel [1]: Export fixed column data C# Use Epplus export Excel [2]: Export dynamic column data C# Use Epplus export Excel [3]: Merge columns continuously with the same data C# Use ...

  8. Excel skill

    <!-- Excel Jump to the specified row, specified column --> =HYPERLINK("#"&ADDRESS( The number of lines to jump to , Number of columns to jump to )," Jump ")

  9. excel skill -- Multiple rows in a single column

    The effect of arranging multiple rows in a single column in the figure above , Doing this : 1. The cell below the penultimate column , write in = Number , Then click on the first cell in the penultimate column . So copy the formula for that cell . 2. Then drag down the bottom right corner of the copied cell , Try to delay ...

Random recommendation

  1. url Parameters with + Number , It's gone after decoding on the server side

    terms of settlement : client :encodeURIComponent Server side :Uri.UnescapeDataString Refer to the website :http://www.cnblogs.com/artwl/archive/2 ...

  2. BZOJ 3111: [Zjoi2013] Ants find their way

    Sol DP. First, look at the turning point , Draw a picture , Look at the mobile route , It's very easy to find that if you go to the bottom of the starting point, you can't go back .. And then it's equivalent to a flat bottom , A concave convex shape at the top , Every two right turns or two left turns forms a small matrix , In this way, we can ...

  3. About downloading DynamicDataDisplay.dll After being locked by default

    problem : Namespace d3:“http://research.microsoft.com/DynamicDataDisplay/1.0” non-existent ChartPlotter Elements reason : download DynamicDataD ...

  4. Thread was being aborted. Did you meet ?

    This Exception There are two reasons for what we have learned :        1.Reponse.Write The problem of ( At present, nine out of ten information found on the Internet is about this problem )      2.Web.Config Set in the exec ...

  5. WPF Hit test example ( Two )—— Geometric area hit test

    original text :WPF Hit test example ( Two )-- Geometric area hit test Continue with the last hit test , This time, let's do a geometric area test example . Example First, create a new one WPF project , Drag a button control into the main interface , And change the following highlight in the code : The current design view ...

  6. Linux Dynamic frequency regulation system CPUFreq The second : The core (core) Architecture and API

    In the last section , Let's talk about it in general CPUFreq In user space sysfs Interface and its several important data structures , Also mentioned ,CPUFreq Subsystems organize some common code logic together , Constitute the CPUFreq The core of , These public ...

  7. golang Related excerpts

    1.golang Development 50 Pit http://devs.cloudimmunity.com/gotchas-and-common-mistakes-in-go-golang/index.html#mli ...

  8. javascript The difference between parentheses

    parentheses JavaScript Parentheses have five meanings semantics 1, Parameter list when function is declared function func(arg1,arg2){ // ... } semantics 2, It is used in combination with some statements to achieve some restrictive effect // and f ...

  9. sgu 176 Upper and lower bound network flow minimum feasible flow with output scheme

    Algorithm steps : 1. First, transform the original image as the maximum feasible flow , The only difference is not to add dst->src That side turns it into a network flow graph with no source and no sink . Run directly to the side of the super source to super sink maximum flow . 2. Add the side that wasn't added just now p 3. Again ...

  10. Linux command - Directory processing command :cd

    cd /tmp/shijiazhuang Switch to tmp Under directory shijiazhuang Catalog cd .. Switch to the previous Directory