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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Industry[/TD]
[TD]Customer[/TD]
[TD]October[/TD]
[TD]November[/TD]
[TD]December[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]May[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Future Table:
[TABLE="class: grid, width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Industry[/TD]
[TD="width: 64"]Customer[/TD]
[TD="width: 64"]Date[/TD]
[TD="width: 64"]Value[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]October[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]October[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]October[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]November[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]November[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]November[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]December[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]December[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]December[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]February[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]February[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]February[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]March[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]March[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]March[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]April[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]April[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]April[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Industry[/TD]
[TD]Customer[/TD]
[TD]October[/TD]
[TD]November[/TD]
[TD]December[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]May[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
Future Table:
[TABLE="class: grid, width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Industry[/TD]
[TD="width: 64"]Customer[/TD]
[TD="width: 64"]Date[/TD]
[TD="width: 64"]Value[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]October[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]October[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]October[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]November[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]November[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]November[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]December[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]December[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]December[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]February[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]February[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]February[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]March[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]March[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]March[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]April[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]April[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]April[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Finance[/TD]
[TD]Cust1[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Tech[/TD]
[TD]Cust2[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Consumer[/TD]
[TD]Cust3[/TD]
[TD]May[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
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...