Formula to move Column to a Row

I am looking for a formula that i can just copy and paste that will take data thats in a column and put it into a row for example

A B C D
1 50
2 125
3 175
4 40
5 30


A Forumla that would put it like this

A B C D E F G H I J K
1 50 125 175 40 30
2
3
4
5

Thank you

Like this...

Data Range

	A	B	C	D	E	F	G
1	50	50	125	175	40	30
2	125
3	175
4	40
5	30
6	-----	-----	-----	-----	-----	-----	-----

This formula entered in B1:

=IFERROR(INDEX($A1:$A5,COLUMNS($B1:B1)),"")

Copy across until you get blanks.