This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
to insert a comma before each column header. The regex [^\s:]*: says "match a string consisting of any number of characters with no spaces or colons followed by a single colon"
This will produce output like
,Status: New ,Manager: Sweety ,Type: General First ,Name: Jon
which you could split into columns using a TextToColumns tool. The rest of the reformatting could probably be done using TextToColumns and a transpose/crosstab combination. Let me know if you have questions about that, or if I've misunderstood what you're data looks like.
Actually, if you know what the column headers are ahead of time, it might be easier to just use some FindString formulas to figure out where the column headers start and end and extract the content from between them, like this (see attached workflow)