Store the values in columns

Help Studio
,
1

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

2

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

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

3

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