As you can see, you get a new table with your data listed in the opposite direction than it was running before.Ĭlick here to watch this video on YouTube.If you have a table that includes both horizontal and vertical data organization, copy the data, right-click on a new cell, and select the Transpose icon in the Paste Options.Copy the data, right-click on a new cell, and then go to the Transpose icon under the Paste Options. If you have a column of data that you’d like to make into a row, the same process applies. As you can see, your data will flip the other way.An example formula might be CONCAT (A2, ' Family'). Close the formula with a parenthesis and press Enter. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Select the cell you want to combine first. ![]() Optionally, if you want to outline an inner, nested group select the rows or columns within the outlined data range, and repeat step 3. Select the cell where you want to put the combined data. On the Data tab, in the Outline group, click Group > Group Rows or Group Columns. Head down to Paste Options > click on the Transpose icon. How do I group rows and columns in Excel Select the data (including any summary rows or columns). ![]()
0 Comments
Leave a Reply. |