3
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 Name
and Field1
fields. 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.
1I see the difference between the two datasheets but I don't understand what the algorithm is for deciding how to shift things around. Please use more unique sample data on the initial dataset to make your objective clearer. – Tony Toews – 2011-06-08T06:42:13.427
Tony, I have data in three columns that I want to appear in one field on a form. The only way I know how to do this at the moment is if the data is in rows as a unique field. I want to be able to only see one item of data at a time, comment on it and click to the next data piece. If there is another way to do this (which I think there is and I cannot remember) then I'll be happy to hear it. – Kelli – 2011-06-08T14:14:26.153