I've been stuck on this for a while. I have two tables, first table of Items is both the list of Items, and the name of some items will be used ad Kit names. Table two is the Kits table, which specifies what goes with which kit. I have an unlimited number of kits, but typically no more than 25 kits. I need to combine into a pivot table. Basically, here's what I have...
Items
| ID | Name |
|---|---|
| 1 | Computer |
| 2 | Keyboard |
| 3 | Mouse |
| 4 | Monitor |
| 5 | Printer |
Kits
| ID | Kit | Item |
|---|---|---|
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 1 | 3 |
| 4 | 2 | 1 |
| 5 | 2 | 2 |
| 6 | 2 | 3 |
| 7 | 2 | 4 |
| 8 | 3 | 1 |
| 9 | 3 | 2 |
| 10 | 3 | 3 |
| 11 | 3 | 4 |
| 12 | 3 | 5 |
Final Output... Needs to have an unlimited amount of "heading" rows...
| Computer | Monitor | Printer |
|---|---|---|
| Computer | Computer | Computer |
| Keyboard | Keyboard | Keyboard |
| Mouse | Mouse | Mouse |
| - | Monitor | Monitor |
| - | - | Printer |
