concatenate rows in column

[ppvtuser]

Table 1

Name_____________Category
Macbook Air_______ Laptops
Macbook Air_______ Computers
Eeepc____________ Netbooks
Eeepc____________ Laptops

Output wanted:

Table 2

Name__________categories
Macbook Air_____Laptops, Computers
Eeepc__________Netbooks, Laptops

How do I achieve the output?

 

[ruve1k]

How many categories can be assigned to each name? Is it a maximum of 2?

 

[ppvtuser]

How many categories can be assigned to each name? Is it a maximum of 2?

No it could be more than 2, thanks

 

[ruve1k]

Is there a reasonable maximum (maybe 4-5) or do you need to accomodate for an infinite number of categories?

 

[ppvtuser]

Is there a reasonable maximum (maybe 4-5) or do you need to accomodate for an infinite number of categories?

yeah 5 is a reasonable maximum

 

[ruve1k]

I broke it up into smaller pieces by creating the following measures:

Category Count:=COUNTROWS(VALUES(Table1[Category]))

Val1:=TOPN(1,VALUES(Table1[Category]),Table1[Category],1)

Val2:=IF([Category Count]>1,", "
&TOPN(1,TOPN(2,VALUES(Table1[Category]),Table1[Category],1),Table1[Category]),"")

Val3:=IF([Category Count]>2,", "
&TOPN(1,TOPN(3,VALUES(Table1[Category]),Table1[Category],1),Table1[Category]),"")

Val4:=IF([Category Count]>3,", "
&TOPN(1,TOPN(4,VALUES(Table1[Category]),Table1[Category],1),Table1[Category]),"")

Val5:=IF([Category Count]>4,", "
&TOPN(1,TOPN(5,VALUES(Table1[Category]),Table1[Category],1),Table1[Category]),"")

CategoryList:=[Val1]&[Val2]&[Val3]&[Val4]&[Val5]

This assumes that you have a relationship between Table1[Name] & Table2[Name].
Then, in Table2 add the following column:

Categories:=[CategoryList]