I appreciate this forum for helping
I need help in combining data from two tables into a Pivot table in Excel My data are like given below
Table 1 that stores the stops between a start and end.
Table 2 that stores how much load was transferred between start and end.
I wanted to combine these table dynamically using pivot table and create a third table that shows the heading as the stops and sums the loads per stops like in table 3
Table 1
Table 2
I want table 3 to be created from these two tables and by linking start and end from table 1 and 2. I tried to setup relationship column but did not work due to duplicity,
I am trying to capture the Pivot or formula in table 3 and save it so I when I change the data in Table 1 or 2 and hit refresh, the table 3 changes automatically.
Really appreciate the help
Table 3
I need help in combining data from two tables into a Pivot table in Excel My data are like given below
Table 1 that stores the stops between a start and end.
Table 2 that stores how much load was transferred between start and end.
I wanted to combine these table dynamically using pivot table and create a third table that shows the heading as the stops and sums the loads per stops like in table 3
Table 1
| Start | End | Stops |
| A | B | A |
| A | B | A1 |
| A | B | A2 |
| A | B | B |
| C | B | C |
| C | B | A2 |
| C | B | B |
| D | E | A1 |
| D | E | E |
Table 2
| Start | End | Load |
| A | B | 10000 |
| C | B | 5000 |
| D | E | 8000 |
| A | B | 9000 |
| C | B | 3000 |
I want table 3 to be created from these two tables and by linking start and end from table 1 and 2. I tried to setup relationship column but did not work due to duplicity,
I am trying to capture the Pivot or formula in table 3 and save it so I when I change the data in Table 1 or 2 and hit refresh, the table 3 changes automatically.
Really appreciate the help
Table 3
| A | A1 | A2 | B | C | E |
| 10000+9000 = 19000 | 10000+8000+9000=27000 | 10000+5000+9000+3000=27000 | 10000+5000+9000+3000=27000 | 5000+3000=8000 | 8000 |
