Data transpose (from vertical input to Horizontal output)

Dear all, after long day , once again , need macro to data transpose from horizontal input to vertical output.
before data

Keisuke Hi
1 ruum · 1 guiter · TKD 90
3-38-5-301 Hazawa, Nerima-ward, TOKYO, 176-0003, Japan
+819038031597 · k123hiro@gmail.com · Japanese
Thursday, May 2, 2013 at 18:35:21 · #664055610

after data

Name	Address	Phone	Email	 Date	sl No
Keisuke Hi	3-38-5-301 Hazawa, Nerima-ward, TOKYO, 176-0003, Japan	819038031597	k123hiro@gmail.com	Thursday, May 2, 2013	664055610

Please check the attachment for better understanding.