Excel rows to columns transpose What is excel transpose function Excel transpose is a very useful function in excel. It is used to switch rows to columns or excel columns to rows. In our regular excel use, we usually come across situations where we need to change excel columns to rows.