Text to Columns Data

[HannahSwain7]

Hi,

I am having issues formatting the data via text to columns and splitting out cells. Attached shows the current status of my data and how I need the output to look.

Would anyone be able to assist please?

Many thanks,

Hannah

[mceleavey]

Hi @HannahSwain7 ,

A simple bit of Transpose and Regex magic does the trick:

Workflow attached.

I hope this helps,

M.

[mathieuf]

Hi @HannahSwain7,

Another way to answer your question with more tools but maybe easier to understand.

Hope this help.