![]() Method-4: Using INDEX Function to Convert Multiple Rows to Columns Read More: Excel VBA: Get Row and Column Number from Cell Address (4 Methods) ➤ Drag the Fill Handle tool to the right side and down.įinally, you will be able to change multiple rows of the main dataset into multiple columns. INDIRECT(“$B$3”) → returns the value of the cell $B$3.
0 Comments
Leave a Reply. |