Store the values in columns

As I fetch values from the text file store in the excel.
But I need to store the values in column by column.
like if I have Name,age,gender as field names which are in A1,B1,C1
I need to store the respective values such as King,22,Male in A2,B2,C2

have a look on the read csv file activity / generate datatable activity

can you share with us the the text file with sample data?

HEADER.xlsx (8.0 KB)
In the sheet2 you can see two column having field and their respective values I need to transpose them sheet 4