How to build an exel table with multiple matching

[_MicheleL_]

Dear All,

Thanks for reading my question.

I need to create a summary table starting from this set of data:
- A: Alphanumeric unique codes;
- B: Alphanumeric unique codes;
- C: Alphanumeric unique codes;

The data are organized in a table where for each couple A, B is possible to have multiple C.

I need to create a data view with:
- A as rows;
- B as columns;
- all the corresponding C in the table fields.

Sample data:

Object	Object code	Vendor Code
Car 1	0001	ab1
Plane	0002	ac3
Ship	0003	ad4
Car 2	0004	ab1
Car 3	0005	ab1

<tbody>
</tbody>

Sample required view:

Vendor Code	car	plane	ship
ab1	0001, 0004, 0005
ac3		0002
ad4			0003

<tbody>
</tbody>

Is the same results you could expect from a pivot but with the list of vaues in the cells instead of the counts.

Please let me know if the topic is clear, any help wold be well accepted.

Thanks,

Michele

 

[_MicheleL_]

Hi Mick,

Its perfect now.

Thanks!

M

 

[MickG]

You're welcome