Well, you could use Retrieve data table column into list to get your column into a list variable. Then use Join text to join the list into a single string with a new line as a delimiter. You could then use Parse text with regular expressions enabled and making sure that it retrieves all matches instead of just the first one to retrieve the values into two separate lists.
The following regex would return the first part: .+(?=,) (everything except for newlines that is followed by a comma)
The following regex would return the second part: (?<=,\s).+ (everything except for newlines that follows a comma and a whitespace).
You'll end up with two lists instead of one.
The problem with this approach is that you cannot really insert a list into a data table as a column. But you can write a list into Excel, if that's the output you need.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
