You might be wondering why we didn’t just add “=A2” to the first empty cell and then just drag it out to autofill the rest. Type your chosen prefix, “bc” in our case (without quotes), into the “Find what” field, and then “=” (without quotes) into the “Replace with” field.Ĭlick the “Replace All” button to transpose your data. Press Ctrl+H on your keyboard to bring up the “Find and Replace” menu. Highlight both of these cells and drag the highlighted area out by clicking and dragging the green box at the bottom right of our selection. For our purposes, that would be cell B2, which we’ll type in as bcB2. In the next cell, below our first one, type in the same prefix and then the cell location to the right of the one we used in the previous step.
This method enables us to find and replace a reference with the data we want to display instead.Ĭlick an empty cell and type in a reference and then the location of the first cell we want to transpose. In our third method of transposing Excel data we’ll use direct references. To correct the data, just go back to the formula bar, and press Ctrl + Shift + Enter one more time. Our data is there now, but the result is a little messed up because of our lack of precision. To fix it, click and drag the box at the bottom, right-hand side of the last cell and drag it out further to include the rest of your data. Instead of pressing “Enter” to execute the formula, press Ctrl + Shift + Enter instead.Īs you can see, our data has been cut off because we didn’t select enough empty cells for our array. Type “=transpose” into the formula bar (without quotes) and then highlight the data you want to transpose. We’re not going to do that we’ll just fix the formula later. In an ideal world we’d count first, as the formula is an array and requires you to highlight exactly the number of cells you need. Click and drag to highlight a group of empty cells.
0 kommentar(er)
