• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Change PivotTable Rows to Columns

How to Change PivotTable Rows to Columns

March 31, 2015
By: Erika Dean
  • Share
  • Share on Facebook

Excel is spreadsheet software that is part of the Microsoft Office Suite. You can use Excel in many ways. You can use it to organize data or to create reports that analyze the data you have entered. You can create a PivotTable report to analyze data, which makes viewing and analyzing the data easier. If you are using a PivotTable and want to change rows to columns, it is easy to do so. Depending on the type of data you are viewing, it may make it easier to analyze by making this change.

Video of the Day

Young businesswoman eating lunch at desk
credit: Siri Stafford/Digital Vision/Getty Images

Step

Open the Excel workbook that has the PivotTable report you want to modify.

Step

Right-click on the PivotTable report, and select "Show Field List." This is where you view all of the fields in the PivotTable, including the report filter, values, columns and rows.

Step

Click on the PivotTable row that you want to change to a column, and drag it over to the box labeled "Column Labels." The row now shows up as a column.

Step

Click on a field that you want to change to a column. Another way to change a PivotTable row to a column is to select "Move to Column Labels."

Step

Repeat as needed to continue changing PivotTable rows to columns.

Show Comments

Related Articles

What Is a Tabular Format?

What Is a Tabular Format?

Around The Home
Productivity
By: David Sarokin
What Are the Different Types of Toolbars on a Window?

What Are the Different Types of Toolbars on a Window?

Around The Home
Productivity
By: Joe Murray
How to Create a Mileage Expense Sheet in Excel

How to Create a Mileage Expense Sheet in Excel

Around The Home
Productivity
By: Tricia Goss
How to Print Address Labels in Excel

How to Print Address Labels in Excel

Around The Home
Productivity
By: Scott Shpak
How to Use Excel for Correlation

How to Use Excel for Correlation

Around The Home
Productivity
By: Shane Hall
How to Split Pages in Adobe Acrobat

How to Split Pages in Adobe Acrobat

Around The Home
Productivity
By: Jen Miller
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.