Hi folks,
Having some issue with the Transpose/Cross Tab tools and wondered if I could get some help?
I've got the following setup;
| Date | Products | Workarea1 | Workarea2 | Workarea3 | Workarea4 | Business Area |
| 01-12-17 | Recieved Today | 300 | 100 | 900 | ... | Site 1 |
| 01-12-17 | Done Today | 250 | 25 | 500 | .. | Site 1 |
| 01-12-17 | Done Today (Rej) | 25 | 25 | 102 | ... | Site 1 |
| 01-12-17 | OTS | 25 | 50 | .. | ... | Site 1 |
That goes down around 7000 rows on an Excel sheet.
I need it to look like the following;
| Date | Work Area | Recieved Today | Done Today | Done Today (REJ) | OTS | Business Area |
| 01-12-17 | WorkArea1 | 300 | 250 | 25 | 25 | Site 1 |
| 01-12-17 | WorkArea2 | ... | ... | ... | ... | |
| 01-12-17 | WorkArea3 | | | | | |
| 01-12-17 | WorkArea4 | | | | | |
| 01-12-17 | WorkArea5 | | | | | |
| 01-12-17 | WorkArea6 | | | | | |
| 01-12-17 | WorkArea7 | | | | | |
| 01-12-17 | WorkArea8 | | | | | |
| 01-12-17 | WorkArea9 | | | | | |
I've been arguing with the Transpose/Cross Tab all morning but can't seem to crack it?
