jascompare.blogg.se

Change row into column in excel
Change row into column in excel











change row into column in excel change row into column in excel

You might want to change this because as time goes on, this data set will get quite wide. The period is going across the columns and the region is going down the rows. The example used in this post contains a small set of sales data by period and region. Why You Might Want to Transpose Your Data When dealing with data, this means you want to change rows into columns and change columns into rows like in the above example.Įssentially, this means flipping the data on the diagonal axis that goes from the top left corner to the bottom right corner. To transpose literally means to cause two or more things to change places with each other.













Change row into column in excel