Скачать или смотреть 12 Short Formula's (Transpose Table, Convert Data Row to Column and Column to Row) by Aamir Ali

"Transpose data in Excel"

(switch rows to columns or vice versa), copy your data, right-click the destination cell, and choose the Transpose icon under Paste Options. Alternatively, use =TRANSPOSE(range) for a formula that updates automatically. The feature works for both vertical to horizontal and horizontal to vertical orientation. 

Method 1: Paste Special (Best for Static Data) 

This method creates a one-time copy of the data that does not change if the original data changes.

Select the range of cells you want to transpose.

Copy the cells using Ctrl+C.

Right-click a blank cell where you want to paste the data.

Under "Paste Options," select the Transpose icon (looks like a small table being rotated).

Alternatively: Right-click - Paste Special - Check "Transpose" - Click OK

This video demonstrates how to use the Transpose feature in Excel: