Transposing rows and columns in a table is one of the most useful tricks when you are pasting data. Yet, it always surprises me that very few people actually know this. So here it is,
To transpose a table of data from rows to columns (or columns to rows)
- Select the table, press CTRL+C
- Goto an empty cell
- Right click and select Paste Special (alternatively press ALT+E followed by S)
- Select “Transpose” check box, it is above the OK button.
- Click Ok. Transposed your data is.
I have made a 15 second tutorial on this. See it below:
(Watch the tutorial on youtube, you can also see it in HD)
15 more tips on pasting data in excel | Transpose Charts | More Quick Tips | More Excel Video Tutorials
One Response to “Excel IF Statement Two Conditions”
At first I thought you missed an opportunity to introduce the IFS and CHOOSE functions, but I see you have those (buried) in the "10 Advanced IF Tricks..." article.
Also, by adding a "Check my results" checkbox (I suggest cell Q3) and a couple conditional formatting rules to apply red/green fill, you could help the users check their formulas.