Transpose data in Microsoft Excel Post author:Author Post published:October 3, 2016 Post category:Excel Tips Change your X and Y axis in Microsoft Excel to turn your columns into rows and rows into columns. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting! You Might Also Like Capitalizing the first letter of each word in Excel with the Proper function September 30, 2016 Secondary Y-Axis in Excel Charts October 5, 2016 Removing Duplicate Rows of Information in Excel March 15, 2018