Trying to figure out the best way to turn my rows into columns, while maintaining the values and headers. Looks like a reverse crosstab query or something. I'm an amateur btw...
I have about 35 columns that I want to stay the same (keep as columns), then about 50 column that have months (Oct_2016, Nov_2016, etc.) across the top where I want the months as a single column with the value next to it.
Example below
Current table:
<tbody>
</tbody>
Future Table:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Any idea how I can do this MS Access? Ideally using the designer type of UI vs. SQL/VBA, but I'm open to anything that works...
I have about 35 columns that I want to stay the same (keep as columns), then about 50 column that have months (Oct_2016, Nov_2016, etc.) across the top where I want the months as a single column with the value next to it.
Example below
Current table:
Industry | Customer | October | November | December | January | February | March | April | May |
Finance | Cust1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Tech | Cust2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Consumer | Cust3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
<tbody>
</tbody>
Future Table:
Industry | Customer | Date | Value |
Finance | Cust1 | October | 1 |
Tech | Cust2 | October | 1 |
Consumer | Cust3 | October | 1 |
Finance | Cust1 | November | 1 |
Tech | Cust2 | November | 1 |
Consumer | Cust3 | November | 1 |
Finance | Cust1 | December | 1 |
Tech | Cust2 | December | 1 |
Consumer | Cust3 | December | 1 |
Finance | Cust1 | January | 1 |
Tech | Cust2 | January | 1 |
Consumer | Cust3 | January | 1 |
Finance | Cust1 | February | 1 |
Tech | Cust2 | February | 1 |
Consumer | Cust3 | February | 1 |
Finance | Cust1 | March | 1 |
Tech | Cust2 | March | 1 |
Consumer | Cust3 | March | 1 |
Finance | Cust1 | April | 1 |
Tech | Cust2 | April | 1 |
Consumer | Cust3 | April | 1 |
Finance | Cust1 | May | 1 |
Tech | Cust2 | May | 1 |
Consumer | Cust3 | May | 1 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Any idea how I can do this MS Access? Ideally using the designer type of UI vs. SQL/VBA, but I'm open to anything that works...