_MicheleL_
New Member
- Joined
- Sep 24, 2014
- Messages
- 6
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:
<tbody>
</tbody>
Sample required view:
<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
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