create each row as a file and each column as the content?

[1]: How can I created each row a a file and each file containing the headers and the value of each column. Thanks.

Example:

      Name Age   Sex
Fi1e1  Maria 24    F
File2  Agnes 23    F
File3   John  23   M

Result: All files Contains the name of each column and the values:

File1
Name Age Sex
Maria 24  F  

File2
Name Age Sex
Agnes  23  F

Thanks.