Hi all,
I need to transform/ re-arrange data in Access. Below table illustrates the data that I currently have:
<tbody>
</tbody>
In order to pivot it, I want it to look like this:
<tbody>
</tbody>
Is this feasible somehow?
I need to transform/ re-arrange data in Access. Below table illustrates the data that I currently have:
Year | FY18 | FY18 | FY18 | FY18 | |||
Month | MAR | MAR | FEB | FEB | |||
Country | Channel | Brand | Item Number | SLS UNT | SLS CST | SLS UNT | SLS CST |
China | RLS | MSW | 10004 | 34 | $87.00 | 56 | $80.00 |
Vietnam | RLE | MSW | 10006 | 32 | $76.00 | 45 | $92.00 |
China | RLC | WSW | 10009 | 29 | $97.00 | 47 | $71.00 |
Thailand | RLS | WSW | 10008 | 17 | $65.00 | 50 | $83.00 |
Singapore | RLC | CSW | 10003 | 0 | 0 | 38 | $91.00 |
<tbody>
</tbody>
In order to pivot it, I want it to look like this:
Year | Month | Country | Channel | Brand | Item Number | SLS UNT | SLS CST |
FY18 | MAR | China | RLS | MSW | 10004 | 34 | $87.00 |
FY18 | FEB | China | RLS | MSW | 10004 | 56 | $80.00 |
FY18 | MAR | Vietnam | RLE | MSW | 10006 | 32 | $76.00 |
FY18 | FEB | Vietnam | RLE | MSW | 10006 | 45 | $92.00 |
FY18 | MAR | China | RLC | WSW | 10009 | 29 | $97.00 |
FY18 | FEB | China | RLC | WSW | 10009 | 47 | $71.00 |
FY18 | MAR | Thailand | RLS | WSW | 10008 | 17 | $65.00 |
FY18 | FEB | Thailand | RLS | WSW | 10008 | 50 | $83.00 |
FY18 | FEB | Singapore | RLC | CSW | 10003 | 38 | $91.00 |
<tbody>
</tbody>
Is this feasible somehow?
Last edited: