Breakdown Hierarchy in one column

[Loai95]

Hey all,

Currently I have multiple pieces of information in one column and I want to break them down so that this column is split into four different columns and each Job has its own row. In sheet 1 I included a sample of the data I have, and in sheet 2 the format I want it in.

[afv2688]

Hello @Loai95,

I cannot see the data. I think you forgot to add it. Could you please do it again?

Thanks

Regards

[Loai95]

Hey @afv2688 

Thanks for the heads up! should be up now

Regards,

[afv2688]

Hello @Loai95,

Try this out

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Loai95]

Hey @afv2688 

Your workflow works, but I had more data than I originally shared and when I asked the question and I thought it won't have any effect on the outcome, but it comes slightly short of how I want it to be

[afv2688 · Accepted solution]

Hello @Loai95,

Issue is fixed now

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Loai95]

@afv2688 Thanks for your help