Convert row into Column in Datatable

[Yoichi]

Duplicated topic

Convert row into Column in Datatable in Studio

Hi, I’m new here, great community! I have a string file containing XML tags, Json tags, and other string formats. I need to write the req and resp data to a table (then to excel). I have delimeters in the file (“#####”). I use the delimeters as both column and row separators. This works well enough - it extracts the data into the table as rows. However, the thing is I was to convert the table in this manner: let’s say we have 2 rows like this: row 1: REQUEST DATA row 2:< message …> … This …