Convert row into Column in Datatable

[Rohi2023 (Roseline Joy)]

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 goes on and on where odd rows will have “REQUEST DATA” or “RESPONSE DATA” and subsequent (even rows) will have the actual xml or json payload

How can I go about doing this please?
Thanks in advance!

[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 …

[Rohi2023 (Roseline Joy)]

Yes it is duplicate, I’m sorry! I made a mistake in this post and tried to delete but it won’t let me.