Excel’s TRANSPOSE function lets you flip a column of values into a row and a row of values into a column. A very useful time-saver if you have a worksheet with data in columns that you need to rotate and rearrange into rows or vice versa.
If you want to see it in action, watch the video below:
The functions that I used in the demos:
=TRANSPOSE(A2:A5)
=TRANSPOSE(F2:F5)
=TRANSPOSE(UNIQUE(C3:I3,TRUE))
=TRANSPOSE(FILTER($A$2:$A$17,$B$2:$B$17=F1))
Download a copy of the file(s) used in this video: https://share.zight.com/YEuEGkEr