How to transform data from columns to rows???

Closed
Saeed1373
Posts
2
Registration date
Tuesday August 2, 2016
Status
Member
Last seen
August 3, 2016
- Aug 2, 2016 at 06:44 AM
Hi i have some data like this:
1 2 3 4
Cell 1 1/11/1900 0:00 5/9/2015 12:40 0.24
Cell 1 1/12/1900 0:00 5/9/2015 12:50 0.08
Cell 1 1/13/1900 0:00 5/9/2015 13:00 0.05
Cell 1 1/14/1900 0:00 5/9/2015 13:10 0.05
Cell 1 1/15/1900 0:00 5/9/2015 13:20 0.05

i want to transform column 1 and column 4 to row 1 and row 2 by a macro i'd be thankful if you guys help me.
1 Cell 1 Cell 1 Cell 1 Cell 1 Cell 1
2 0.24 0.08 0.05 0.05 0.05