Summarizing and removing duplicates

[Cesc]

I would like to go from A to B by summarizing all references to each of the books (summarize by book) Don't have a clue how i can do that with Alteryx

A

B

[Cesc]

this is the book from screenshot in case someone can show me how to with example

[MilindG · Accepted solution]

[Cesc]

Thank you very much milind, thats what i was looking for!!!!!

[MilindG]

@Cesc  Cheers, glad to help!