Now, select the range of cells from the dataset (your multiple columns). After that, press Alt+F8 on your keyboard to open the Macro dialog box. Set output_range = output_range.Offset(0, num_of_columns + 0) Set output_range = Application.InputBox("Enter the Cell where you want to paste:", xTitleId, Type:=8) Set input_data = Application.InputBox("Select Your Range :", xTitleId, input_data.Address, Type:=8) XTitleId = "Convert Multiple Rows to a Single Column" Then, click on the Insert > Module option.ĭim input_data As Range, output_range As Range. First, press Alt+F11 on your keyboard to open the Visual Basic editor. This method will effectively convert multiple columns to a single row in Excel. Now, if you love to solve Excel problems using Microsoft Visual Basic for Applications, you will like this one. VBA Codes to Convert Multiple Columns into a Single Row Read More: Convert Columns to Rows in Excel Using Power QueryĢ. 
Now, you can change these values according to your needs. (COLUMN()-1,3)/3: Like the row, 3 also indicates the column number here.
(ROW()-1)*3: Here, 3 stands for the row number. Dataset!$B$4: It specifies the sheet name and the range reference that you want to use.
0 kommentar(er)
