EXCEL TIPS & TRICKS

Transpose Columns & Rows for new Data Layout

1. From your Excel sheet, select the desired cells you want changed.

2. Right-Click and select ‘copy’ option.

3. In empty cell, Right-Click and choose Paste Option — Transpose

Or Paste Special

and select Transpose

now its in column format

5. You can also transpose entire sections: Highlight desire Area.

(Copy / Transpose)