Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel.

A ) Switching

B ) Transpose ✅

C ) Matrix

D ) None of these