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