Good afternoon,
Looking for a little help please. I have attached a file which has an original Input of data and a desired Output of data.
Basically all I want to do is merge or group the cells by column where the data is the same but leave the different rows intact. Easy to do in Excel, but time consuming, and wanted to automate this with Alteryx.
In my example columns A-E are the same (Column A dictates the main Ref No.); columns G-L are different.
How can I do this in Alteryx or at least what tool should I be looking use?
Apologies if this is very simple, but I have been trying every tool that I can think of that may help me.
Kind regards
Mike
