Single Column to Table

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.

SampleData1.xlsx

Developer Tools

Accepted answers

Emil_Kos

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 🙂

Workflow4.yxmd

All comments

AngelosPachis

Hi @Asalmeida ,

I think this workflow might do the trick. I have used the annotations to explain what happens in each step but feel free to reach out if there are any further questions.

Cheers,

Angelos

example.yxmd

Asalmeida

Hi AngelosPachis,

Thank you for your response and time.

I had to change the Assign column ID multi row formula to
IF CONTAINS([row-1:Input],"X")
THEN 1
ELSE [Row-1:Column ID]+1
END IF

And the create groups multi row formula to

IF CONTAINS([row-1:Input],"X") THEN [Row-1:Group]+1
ELSE [Row-1:Group] ENDIF

Since the X is only part of the data cell. Is there anything wrong with this changes?

I also had to change the replace the change columns formula since my data set has 29 or 30 cells per group instead of 7 or 8 that I have in the sample.

Most of it look fine, but in the rows that have 29 cells with data he last one -"X" doesn't show. And some cells aren't shifting correctly but that should all be related.

Thank you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703