I started it all wrong with some excel table and decided I need to switch rows with columns and thought that it takes me some time to actually do it manually or find a feature in excel to do it.
Excel to the rescue: Transpose
Just select the table or rows/columns then CTRL-C, go to a new Sheet or wherever and CTRL-V, then select T or transpose icon. Done.
I just have not been able to do this without choosing another place or Sheet, i.e. no same place transpose? Anyone any idea?
No comments:
Post a Comment