Convert a two-dimensional Excel table to one-dimensional

Source: Internet
Author: User

Convert a two-dimensional Excel table to one-dimensional

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:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.