How do EXCEL2013 table data combine multiple columns into one column?

Before we talked about how to transpose a column of data into more than one row and column, we must be familiar with this approach, so what do we do when we turn to a column of multiple rows and columns of data? I'm sure you have the answer.

How does an Excel table convert a column of data into multiple rows and columns of data?

1, the same we will see the following data, such data if a lot of words, will give us a lot of data processing trouble.

2, first in the penultimate column of data in the first cell, enter the first cell in the last category of =h1,h1, the Drop-down Quick Fill button, as shown in Figure 2 below, as much as possible.

3, and then the bottom right corner of the last cell, continue to pull left to the first category of data column, this time we will find that the first column of data need to get the last type of data can be

4, then we will find that the first column of data is what we want, copy Save as a value, everything OK!