Join multiple rows into one row

[abbas50]

Hello all,
I need help doing the following i have same URL in first column repeated 7 times in a second column Diffrent value i want to join them into 1 row like this

Thank you for your help appreciated !

 

[sandy666]

you can use Power Query and Group feature
post copyable data with XL2BB

btw. PQ doesn't support url so result url's will not be clickable

 

[abbas50]

you can use Power Query and Group feature
post copyable data with XL2BB

btw. PQ doesn't support url so result url's will not be clickable

there is no formulas for such things? as i never used power query in my life and i dont mind if urls clickable or not thank you in advance!

 

[sandy666]

I don't know if there is any formula to do that, maybe any Formula Master will give you solution

btw. you've XL2016 so there is Power Query (Get&Transform) built-in

 

[abbas50]

ADVERTISEMENT

I don't know if there is any formula to do that, maybe any Formula Master will give you solution

btw. you've XL2016 so there is Power Query (Get&Transform) built-in

Found the solution :D TY for the information mate

 

[sandy666]

You are welcome

 

[mehidy1437]

Sorry guys, a mistake.

 

[mehidy1437]

This work in my test.

Book1
	A	B	C	D	E	F	G	H
1	Product			Product	Color 1	Color 2	Color 3	Color 4
2	123456	black
3	123456	white
4	123456	orange
5	987654	black		123456	black	white	orange	pal blue
6	987654	green
7	147258	white
8	147258	black
9	123456	pal blue
Sheet1

Cell Formulas
Range	Formula
E5:H5	E5	=IFERROR(INDEX($B$2:$B$18,SMALL(IF($A$2:$A$18=$D5,ROW($A$2:$A$18)-ROW($A$2)+1),COLUMNS($D5:D5))),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Information got here, Transpose and Index