Displaying Questions in different columns - not rows in visualisations

[lloyd.m (Mark Lloyd)]

In the below visualisation, each of the rows relates to a different question – instead of creating multiple rows, how can I create a new column for each of the questions?

I would like it to look like this:

Can anyone advise on how to do this?

Thanks

Mark

[copy_writes (chethan)]

@lloyd.m

In the below visualisation, each of the rows relates to a different question – instead of creating multiple rows, how can I create a new column for each of the questions?

// Read original DataTable
Read Range activity → Output DataTable: OriginalDataTable

// Transpose DataTable
Transpose DataTable activity → Input DataTable: OriginalDataTable
→ Output DataTable: TransposedDataTable

// Write Transposed DataTable to Excel
Write Range activity → DataTable: TransposedDataTable
→ Sheet Name: YourNewSheet
→ Excel File Path: YourFilePath

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @lloyd.m ,
You can write each row from old file to new file, each row have an empty row
regards,