Hi,
I would like to split a text from multiple lines text input to columns first, then to rows. Here's what I have:
123
456
789
;
aaa
bbb
ccc
Here's what I want to have:
123 aaa
456 bbb
789 ccc
I used Collect and Split functions which gave me this:
123456789 aaabbbccc
Collect(customText,
{
kolumna1: First(Split(TextInput1.Text,";")).Result,
kolumna2: Last(Split(TextInput1.Text,";")).Result
}
);
Is there any way to split each of the rows to columns or any other way to get the result I need?
