How to rearrange data across rows to columns?

1. Select the group of cells across the row containing data

 2. Right Click on the selection and choose copy.

 3. Select any cell on the workbook, then right click and choose paste special.

4.  In the Paste Special Dialog Box choose Transpose and click OK.

5. The same method can be used to rearrange data across columns to rows.