This is a very useful function in Google Sheets but not many people know it
there are times when you need to convert columns into rows or convert data from rows to columns, of course, retyping 'manually' takes time, so remember the transpose function,