A macro to copy data into new worksheets

Closed
dnick94
Posts
1
Registration date
Tuesday December 30, 2014
Status
Member
Last seen
December 30, 2014
- Dec 30, 2014 at 10:08 AM
Hello,
I am looking to write a macro to copy information in rows, and paste them into new worksheets by columns e.g
DataSheet:
Name¦ Country¦ City¦ DOB¦ Gender¦
John¦ UK¦ London¦ 04/05/1990¦ Male¦
David¦ UK¦ Sheffield¦ 12/12/1985¦ Male¦
Lucy¦ UK¦ London¦ 17/06/1989¦ Female¦
So i want the data from this worksheet to get pasted into 3 separate worksheets with the worksheet names as the persons Name and the data transposed into column and titles re-arranged so for example the first worksheet would look like

Name¦ John
DOB¦ 04/05/1990
Gender¦ Male
Country¦ UK
City¦ London

Thanks in advance, and sorry i didn't know how to space out the columns