Share via

restructuring a table

Maysam 1 Reputation point
2020-11-02T05:11:11.91+00:00

Hello,
I have a data of 1700 rows and 10 columns. I want to change the layout of this table. Attached36557-sample.jpg is a sample:

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,708 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 9,006 Reputation points
    2020-11-02T12:11:40.853+00:00

    @Maysam

    Assuming you run (at least) Excel 2016 on Windows this can easily be done with Get & Transform aka Power Query:

    36820-msanswer.png

    1/ Format your data as a Table
    2/ From the Data tab > From Table/Range (Power Query editor opens)
    3/ Delete step "Changed Type"
    4/ Select column [Company]
    5/ From the Transform tab > Unpivot columns > Unpivot Other Columns
    6/ Rename column [Attribute] as [Year]
    7/ Change the column data Types
    8/ File > Close & Load To...

    Sample avail. here (download a copy as Get & Transform doesn't work in Excel online)

    If you're on Excel 2010/2013 for Windows this is the same process, after downloading and installing the Power Query add-in

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.