Mapping against multiple columns

[Metadata21]

Alteryx pals I require your help! 

I'm assuming this is easier than I think but I cannot get my head around it. 

I require row 3 to be mapped to row 2 as the data correlate with one another.

thank you!

[IraWatt]

Hey @Metadata21,

You didn't say which columns to look at to tell if rows are correlated so I just assumed it was the first 4 which I highlighted:

This approach moves all the data for rows with the same Source, Date, Vendor and Invoice onto one line. 

This solution uses the transpose and cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[binuacs]

@Metadata21 Looking for something like the below?