Concatenate multiple unique values with same source value

[Guitarmageddon]

hello everyone, tried doing with dax and regular excel methods but scratching my head

here is a table example. the "style" number is repeated because there are multiple vendors that source the product. i simply want to concatenate each of the vendor names together separated by a comma. how would I do this?

for example, the first style, (ending in 715) would concatenate "service command , s c johnson & son inc"

STYLE	VENDOR NUM	VENDOR NAME	Vendor Style
00000000333715	00001707694	SERVICE COMMAND	333715
00000000333715	00006091417	S C JOHNSON & SON INC	333715
00322474385441	00147491195	SCOTTS MIRACLE GRO CO(BAG GDS)	4385404
00465007111071	00001707694	SERVICE COMMAND	71110
00465007111071	00006091417	S C JOHNSON & SON INC	71110
00465007111141	00001707694	SERVICE COMMAND	7693098
00465007184891	00001707694	SERVICE COMMAND	71848
00465007184891	00006091417	S C JOHNSON & SON INC	71848

<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="229" style="width: 172pt; mso-width-source: userset; mso-width-alt: 8374;"> <col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;"> <tbody> </tbody>

 

[Tom.Jones]

Hi,

Which version of excel do you use?
What do you want, formula, or VBA code?

 

[Guitarmageddon]

Hi,

Which version of excel do you use?
What do you want, formula, or VBA code?

Hello! 2016... VBA could work fine. In the future, Id like it to be flexible where I may run into the same situation, but just with different parent column names, but you get the concept. Also, there are a few occurences in the data set that are more than 2 vendor names for a style, if that matters

 

[Rick Rothstein]

Perhaps you can make use of the code I posted in my mini-blog article here...

http://www.excelfox.com/forum/showthread.php/345-LookUp-Value-and-Concatenate-All-Found-Results