Summarise Data

[SandyCovey]

Hi All,

I have a workflow which produces an excel file with invoice data from our Financial system, there are sometimes several lines per invoice. I want to summarise the data into 1 line based on 3 columns, company ID, document type and document number, i.e. if the data in these 3 columns are duplicated summarise into 1 line. I can't get the summarise tool to work as it only outputs the fields I summarise on. Help on this would be appreciated.

[binuacs]

@SandyCovey Can you provide sample data and expected output for the better understanding or your use-case?

[aatalai]

@SandyCovey take a look at the unique tool that might help. Let me know how you get on

[Raj · Accepted solution]

@SandyCovey 
find the workflow attached
hope this helps

if you are looking for something else please add sample input and expected output
mark done if solved.