Comma Separated Table

[Inactive User]

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.

[apathetichell · Accepted solution]

check out my take on it. I added the table at the end and wasn't quite sure if you wanted the V's kept as a second header set. If you do let me know and I can re-run it.