I have a data sheet that looks like:
Name Field1 Field2 Field3 Field4 John Doe AAA BBB CCC DDD John Doe AAA BBB CCC EEE John Doe AAA BBB CCC FFF
I want it to look like:
Name Field1 Field2 John Doe AAA DDD John Doe BBB EEE John Doe CCC FFF
At the very least the
Field2 is optional.
Is there a way to do this quickly and easily in MS Access or MS Excel? The transpose option in Excel doesn't quite cut it. I know there is a (probably) a query process in Access, I just cannot remember at the moment.