mopafusion.blogg.se

Then drag the formula down to the cell until the error information is displayed. Note: MyData is the range name of the selected data, you can change it as you need.ģ. After specify the range name, then click a blank cell, in this example, I will click cell E1, and then input this formula: =INDEX(MyData,1+INT((ROW(A1)-1)/COLUMNS(MyData)),MOD(ROW(A1)-1+COLUMNS(MyData),COLUMNS(MyData))+1). In the New Name dialog box, enter the range name you want. First, define a range name for your range of data, select the range data that you want to convert, right click and choose Define Name form the context menu. The following long formula can help you quickly transpose a range of data into a column, please do as this:ġ. Transpose/Convert columns and rows into single column with Kutools for Excel Transpose/Convert columns and rows into single column with VBA code

Transpose/Convert columns and rows into single column with formula When you use Excel worksheet, sometimes, you will meet this problem: how could you convert or transpose a range of data into a single column? (See the following screenshots:) Now, I introduce three quick tricks for you to solve this problem. How to transpose / convert columns and rows into single column?