Why Convert Columns to Rows?īefore we get started, you might be wondering why it's so helpful to take data that's structured in many columns and convert it into rows. In this tutorial, you'll learn how to use Power Query to convert columns into rows in Excel. Take your Excel skills to the next level by 'unpivoting' your data using Microsoft Power Query. One of the most popular data cleanup steps is to take data that's spread across columns and convert it into rows of data. Power Query, also called 'Get and Transform Data' lives inside of Excel and automates the data cleanup process. That's where Power Query comes into play. Microsoft Excel is a very user-friendly tool, but you still need to clean up your data before it's usable for analysis and review.

You need a way to re-arrange and clean up your data to make it usable. To switch the rows and columns in an excel chart, follow the methods below.Ĭreate a statistical table or used an existing one.The problem is not that we lack data, it's that we have so much data that it's hard to find meaning inside of it.

Create a chart or use an existing chart.

It’s a feature that transforms the data in the chart.

The Switch Row or Column feature allows the user to swap data over the axis the data on the X-axis will move to the Y-axis.

So you can switch the rows to columns so that the data can demonstrate the way you want this is done using the Switch Row/ Column button.

When creating a chart, the program figures out the correct way to organize the data the program determines which to labels to assign to the horizontal axis and where to put the chart’s legend, but what if there is an error? For instance, you want the rows of the data displayed on the horizontal axis to be displayed on the vertical axis instead.

Change columns to rows in excel