I've been an Excel user for years and am trying to switch over to Numbers. I cannot figure out how to take a row of numbers and transpose it to a column (values only....not by using a formula). With Excel it was pretty straight forward but I'm really lost trying to figure this out using Numbers. Help???
It is difficult to search these forums. A similar question was asked a few days ago. I had to scan though a few pages of posts before I found the one I was looking for (see link below).
Numbers will transpose an entire table, not a range of cells. You can easily turn a range of cells into a table, transpose it, then put the cells where you want them in your original table. A few ways of doing this are in the thread linked below. It gives the basics of how to do it. There are other variations on the same methods.
https://discussions.apple.com/thread/253314361?answerId=256197690022#256197690022
Thank you! What a time saver.
transpose single row to Columbus
