brendanolear
Active Member
- Joined
- Apr 26, 2008
- Messages
- 366
I have a basic table I wish to transpose but can't seem to do so in access.
I use the normalization method excel, but can't see how it can be achieved in access.
Current Table at top and outcome I seek is below
<colgroup><col width="90" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3185;">
<col width="166" style="width: 124pt; mso-width-source: userset; mso-width-alt: 5888;">
<col width="64" style="width: 48pt;" span="3">
<tbody>
</tbody>
I use the normalization method excel, but can't see how it can be achieved in access.
Current Table at top and outcome I seek is below
Product Code | Product Name | P01 | P02 | P03 |
AA01 | Lundry | Tom | Tom | Eric |
AA02 | Presto | Bob | Tom | Bob |
AA03 | Parsa | Eric | Tom | Eric |
Product Code | Product Name | Period | ||
AA01 | Lundry | Tom | ||
AA01 | Lundry | Tom | ||
AA01 | Lundry | Eric | ||
AA02 | Presto | Bob | ||
AA02 | Presto | Tom | ||
AA02 | Presto | Bob | ||
AA03 | Parsa | Eric | ||
AA03 | Parsa | Tom | ||
AA03 | Parsa | Eric |