Reference table
enter image description here
Item code Value
A x
A y
A z
B l
B m
C n
D o
D p
Desired output
enter image description here
Item code Value(s)
A x, y, z
B l, m
C n
D o, p
I wanted to use a formula on Google sheets that would give me the desired output.
Can someone please help?
Tried Index match but failed, I could be doing something wrong
New contributor
Ninad Vichare is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.