I have been trying to figure out how to transpose a query per a customer request (they want to read the information horizontally instead of vertically). But I am struggling with the Crosstab query in access. Is there a way to transform the below data:
to look like this?
Week Order | Calendar Week | LDOW | Previous Friday Est Revenue | Planned Weekly Revenue | ActualRevenue | Committed Purchases | Est Purchases |
1 | 33 | 8/16/25 | 39,842.10 | 21,084.30 | 10,974.58 | 2,169.54 | 2,319.17 |
2 | 34 | 8/23/25 | 59,124.08 | 48,174.08 | 1,012.50 | 20,933.53 | |
3 | 35 | 8/30/25 | 55,781.46 | 42,423.85 | |||
4 | 36 | 9/6/25 | 35,008.90 | 64,910.94 | 11,424.56 | ||
5 | 37 | 9/13/25 | 28,256.80 | 19,306.80 | 306.00 | ||
6 | 38 | 9/20/25 | 10,076.70 | 15,982.60 | 4,436.39 | 5,936.19 | |
7 | 39 | 9/27/25 | 23,050.25 | 23,920.41 | 2,834.59 | 9,510.31 | |
8 | 40 | 10/4/25 | 6,680.90 | 10,425.90 | 5,241.50 |
to look like this?
Week Order | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Calendar Week | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |
Last Day of Week | 8/16/25 | 8/23/25 | 8/30/25 | 9/6/25 | 9/13/25 | 9/20/25 | 9/27/25 | 10/4/25 |
Previous Friday Est Revenue | $39,842.10 | $59,124.08 | $55,781.46 | $35,008.90 | $28,256.80 | $10,076.70 | $23,050.25 | $6,680.90 |
Planned Weekly Revenue | $21,084.30 | $48,174.08 | $42,423.85 | $64,910.94 | $19,306.80 | $15,982.60 | $23,920.41 | $10,425.90 |
Actual Revenue | $10,974.58 | |||||||
Committed Purchases | $2,169.54 | $1,012.50 | $0.00 | $0.00 | $306.00 | $4,436.39 | $2,834.59 | $0.00 |
Est Purchases | $2,319.17 | $20,933.53 | $0.00 | $11,424.56 | $0.00 | $5,936.19 | $9,510.31 | $5,241.50 |