I am using two tables to create three pivot tables.
One of the tables provide the container number and PO numbers for each container.
The other table provides the container number, cbm's, total cases and vessel the container came off of. I need all of the above information but beings the table's do not coilate with each other I cannot mesh them and create one pivot table. I'm working with it pretty well with the three pivot tables because it is a simple copy and paste.
The only thing that is time consuming is when I have to paste each PO that is related to each container. Sometimes, there are numerous PO numbers. Is there any way, when creating the pivot table, for it to transpose the PO's?
Currently:
[pre]
[/pre]
One of the tables provide the container number and PO numbers for each container.
The other table provides the container number, cbm's, total cases and vessel the container came off of. I need all of the above information but beings the table's do not coilate with each other I cannot mesh them and create one pivot table. I'm working with it pretty well with the three pivot tables because it is a simple copy and paste.
The only thing that is time consuming is when I have to paste each PO that is related to each container. Sometimes, there are numerous PO numbers. Is there any way, when creating the pivot table, for it to transpose the PO's?
Currently:
[pre]
Code:
7/28/2012 | ABCD1234567 | 123456
357995
654665
| DFEK4567894 | 798465
| WERE4654615 | 654651
Would like for it to do:
7/28/2012 | ABCD1234567 | 123456 | 357995 | 654665
| DFEK4567894 | 798465
| WERE4654615 | 654651