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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |