A Google Sheets tip to brag about!

[Uncle Gizmo]

This fancy Google Sheets formula is the coolest function you’ll never use

Good luck with finding a purpose for this, other than boasting your spreadsheet skills.

thenextweb.com

 

[isladogs]

The TRANSPOSE function has been available in Excel for many years and is very useful.
Same idea as a crosstab query in Access.