data reformatting

[Yoba1Two]

Hello Alteryx community, 

I'm pretty new to Alteryx and so far it's amazing.. just I have one thing that I couldn't figure how to do it (used to do it Excel but it takes time and a lot of manual work..) and the reason I started using Alteryx was to automate it.. 

so I have this dataset with duplicates in MATNR field. each row is unique 

There are from 1 to 6 occurrences for each MATNR (1 min and 6 max)

The idea is to transform the data above into something like this

So each column from the initial dataset will be repeated 6 times except for MATNR which is the key 

for example for MEINH I'll have MEINH_1, MEINH_2...MEINH6 and for UMREZ I'll have UMREZ_1, UMREZ_2...UMREZ_6 and so on 

So the end result for the first MATNR for ex 1002324 should look like this 

Many thanks indeed for your help 🙂 

[TheOC]

hey @Yoba1Two 

can you please attach your input dataset?

If not i can try to get it working with a quick example.

Cheers,
TheOC

[Yoba1Two]

Yes, here is a sample from my dataset 

Thanks you for the quick answer 

[binuacs]

Spoiler

[Yoba1Two]

Hello @binuacs, 

Thank you for your help 

I tested it and not sure why I'm getting it like this.. did you change anything in the sample dataset? 

and it goes MEINH_1, MEINH_2....MEINH_16 while it should only be 6 for each.. 

Any idea on how to fix this?

[binuacs]

@Yoba1Two  the files are writing up to 5 ie MEINH_1, MEINH_2....MEINH_5. Not sure why you are getting different result> I am attaching the workflow again

Spoiler

Spoiler