This is in Excel 2007
I got a large raw database and want to organize it in a better way
right now the raw data look like
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I would like to organize it in such a fashion
<tbody>
</tbody>
and so forth
I'm not sure how many different types of columns there are and the the pivot table doesn't like it.
I got a large raw database and want to organize it in a better way
right now the raw data look like
TYPEID | MATERIALTYPEID | QUANTITY |
18 | 34 | 256 |
18 | 35 | 512 |
18 | 36 | 256 |
19 | 34 | 71000 |
19 | 35 | 9000 |
19 | 40 | 140 |
20 | 34 | 386 |
20 | 36 | 773 |
20 | 37 | 386 |
21 | 35 | 290 |
21 | 37 | 708 |
21 | 38 | 354 |
21 | 39 | 32 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I would like to organize it in such a fashion
Type ID | 34 | 35 | 36 | 37 | 38 | 39 | 40 |
18 | 256 | 512 | 256 | 0 | 0 | 0 | 0 |
19 | 71000 | 9000 | 0 | 0 | 0 | 0 | 140 |
20 | 386 | 0 | 773 | 386 | 0 | 0 | 0 |
<tbody>
</tbody>
and so forth
I'm not sure how many different types of columns there are and the the pivot table doesn't like it.