First, I made an assign with
text(Key) = “TEST1 TEST2 TEST3 TEST4\t\n DATA1 DATA2 DATA3 DATA4”(Value)
And then I used Split method …
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 file
Anyone can give me solution?..
Here is my sample .xaml filecolumn&row.xaml (11.2 KB)