Hi,

Select the range then press Ctrl + C to copy.

Select the first cell where you want the data to go then right click in the cell and select paste special

Tick the transpose button and ok



VBA Noob