Single Column to Table

[Asalmeida]

Hello,

I have been trying to work my way around this but couldn't make it happen. I just started using Alteryx and this seems to be out of my reach.

My data is in a single column and I want to make it look like the following:

-The data represented by the same letters isn't the same but refers to the same attribute.
-Some data groups have 8 rows, some have only 7.

-If Row G isn't present I would need to shift row F to Column7
-X is the last data cell for each group, and a part of it is always the same, so that can be used.

Many thanks in advance for you help.

[Emil_Kos · Accepted solution]

Hi @Asalmeida,

I don't have sample data but I created something for you. I have added one multi-row formula that will identify cases with 2 

Probably you will need to look into this formula tool. I hope you will be able to make it work 🙂 

[Asalmeida]

Got it done! Thank you so much for your help Emil, have a great day!!