In PQ combing values from multiple rows in a column

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

solved

Post Body

On phone sorry!!

I have a tint bit of PQ experience but this is really outside my box.

In column A I have references Column B will be the same per reference Column C will be the same per reference Column D has different values that I need to combine

A. B. C. D

Set 1. 26. 22 FISH

Set 1. 26. 22 CHIPS

Set 1. 26. 22 SAUCE

Set 2. 29. 42 CRISPS

Set 2. 29. 42 PIZZA

What I need to come out of it is:

A. B. C. D

Set 1. 26. 22 FISH, CHIPS, SAUCE

Set 2. 29. 42 CRISPS, PIZZA

Any help would be much appreciated.

Author

Account Strength

10%

Account Age

1 year

Verified Email

Verified Flair

Total Karma

382

Link Karma

Comment Karma

381

Profile updated: 4 days ago

Posts updated: 1 day ago

Key_Possibility6235

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 4 months ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...