How can I make Datatable to Excel with this Assign(with string data) Activity?

[RPA_newbie]

I made an assign with
Text(key), and its inside data is “TEST1 TEST2 TEST3 TEST4\t\nDATA1 DATA2 DATA3 DATA4”

What i want to make is ▼
Make Columns with ‘TEST1 TEST2 TEST3 TEST4’, make Rows with ‘DATA1 DATA2 DATA3 DATA4’
After that make it to Datatable → Excel

First of all, I used Split method to ‘\t\n’, and then used ‘For each’ activity with split data.
After then, I used Split method to blank(" "), and then used ‘For each’ activity with split data.

But now, I stuck in this step. I don’t know how can I make Datatable to Excel with this.
What I want to ask, anyone can give me some help to solve this problem?

Here is my .xaml file, please take a look and help me, or you guys can make it for me with using my .xaml file.
Column_Row(eng_ver).xaml (12.5 KB)

Thanks for reading guys !

▼ Screenshot Sample

[pravin_calvin (pravin kumar)]

Hi @RPA_newbie
Please check with the xaml
Column_Row(eng_ver).xaml (11.3 KB)
Thanks

[RPA_newbie]

oh, sorry dude, I forgot write about this.

What i want to make is ▼
Make Columns with ‘TEST1 TEST2 TEST3 TEST4’
Make Rows with ‘DATA1 DATA2 DATA3 DATA4’
After that make it to Datatable → Excel

[pravin_calvin (pravin kumar)]

Hi @RPA_newbie
please check with the below xaml.

Column_Row(eng_ver).xaml (15.7 KB)

Thanks

[RPA_newbie]

Ahh thank you,
But what if there are so many data more than DATA4, like DATA1 ~ DATA 100.
We can’t use this way i think. Am I right?

Then how can I change this Algorithm(Logic) from this .xaml file?

I think I have to use another ‘for each’ activity… but how, will you let me know how to do it?

[RPA_newbie]

Thank you.
your solution is correct.
Thanks for the help ! !