Convert a two-dimensional Excel table to a one-dimensional excel table

Convert a two-dimensional Excel table to a one-dimensional excel table

Author: iamlaosong

There is a two-dimensional table, which is the customer name in the vertical direction, the product name in the horizontal direction, and the content is the number of products required by each customer. Now we need to change this two-dimensional table into a one-dimensional table, the content is the customer name, product name, and quantity. I remember that the pivot table can be used to complete this function, so I searched the internet and found the desired answer. There is no problem in following steps, see Baidu experience for operations: how to convert two-dimensional excel into one-dimensional

The Pivot Table wizard is used, which is not usually visible. You can use the following link to perform the operation:

Excel2007, 2010 where is the pivot table and pivot wizard?

As we know, pivot tables are usually used for data analysis. its normal function (the first item in the Wizard) can easily convert a one-dimensional table into a two-dimensional table, for example, if we use the one-dimensional table we made to generate a pivot table, we only need to change the product name as a field into a two-dimensional table. Similarly, we can also change the customer name as a field to a two-dimensional table, in the pivot table wizard, the "Multi-merge computing data regions" function can convert two-dimensional tables into one-dimensional tables. Therefore, you can easily convert one-dimensional and two-dimensional tables using the pivot table.

For the pivot table wizard, see:

How does ExceL convert two-dimensional data into one-dimensional data?

Copy all the data that is rampant first, right-click the other part, and select "paste...". There is a "transpose" in it, but then click OK.
 
Converting an EXCEl one-dimensional table into a two-dimensional table

You can create a simple Pivot table.
This function is the essence.



MEIFEG... [authoritative expert]