I have data coming from a database that essentially has a row for each item in warehouse. If it is in multiple warehouses it has multiple rows. I would like to transform this data into each item only having one row, but with each warehouses information changed into columns.
| Item code | DC | Status | Cost |
| 3556 | 1 | 5 | 22 |
| 3556 | 2 | 5 | 22 |
| 3556 | 3 | 2 | 24 |
| 4225 | 1 | 1 | 21 |
| 4225 | 2 | 1 | 21 |
| 4225 | 3 | 3 | 26 |
| 5332 | 1 | 2 | 20 |
| 5332 | 2 | 1 | 20 |
| 5332 | 3 | 4 | 12 |
Above is sample of what the pull from the database looks like. I have 3 separate warehouses (DC) and a status and cost associated with each. Below is how i would like the data to look.
| Item code | DC 1 - Status | DC 2- Status | DC 3 - Status | DC 1 - Cost | DC 2 - Cost | DC 3 - Cost |
| 3556 | 5 | 5 | 2 | 22 | 22 | 24 |
| 4225 | 1 | 1 | 3 | 21 | 21 | 26 |
| 5332 | 2 | 1 | 4 | 20 | 20 | 12 |
