Copy/Paste data from another sheet Value in Rows paste in Columns

If someone could help me figure out keep the row the same when pasting and change the column when pasting to a column that would be wonderful.

I’m having the most trouble trying to figure this out??

I have values in row 5 and want to paste the same values to a column on a different sheet.

Example:

A5=B1
B5=B2
C5=B3
D5=B4
And so on.

Thanks to whoevers looking at this!!

Thank You,
Brian

Hi Brian,

Tell me you have tried to Copy and then Paste Special with the Transpose box checked. If you've done that then I'll understand the problem a little better.