Hello!
I am looking to find a way to create a table from a data set that is in a single cell, separated by commas (including the headers!).
I don't need a workflow built out, though I am looking for advice on tools that can accomplish this. For example, I have the data set connected to a Text to Columns tool and I have it set up to rows (which created 200+ rows), I tried to connect it to another Text to Columns to then output the rows as columns, though there doesn't appear to be a way to determine what I want my headers to be. I used the formula tool to create new headers, though can the formula tool filter what data is within each column? I tried a few expressions, though it either returns as null or the first value in the data set.
