simplest way in Excel to combine (merge)

[ValentinCVE]

Hi all,

What is the simplest way in Excel to combine (merge) multiple rows data corresponding to a unique value in large dataset? output should be: x=a,b,c,d. Already tried power pivot, pivots.

 

[vletm]

ValentinCVE​

You could get some possible way after You've sent a sample Excel-file as well as expected correct result based Your sample data.

 

[Marc L]

Hi, maybe with Power Query …​

​

 

[pecoflyer]

Hi. What is your XL version? In recent versions the TEXTJOIN function is a possibility

 

[Peter Bartholomew]

FILTER, followed by TEXTJOIN would come to mind.