kc.crow
Board Regular
- Joined
- Jul 7, 2005
- Messages
- 75
Hello
I've searched quite a few places and I'm sure that I'm not using the correct keywords because this shouldn't be difficult.
I have data that has the same "keys" (ID, Name, Title) but will have other columns that may or may not have a value. Below is an example of what I mean.
ID| Name| Title| Field1| Field2| Field3
01| Joey| CEO| Value1
01| Joey| CEO| _______ Value2
01| Joey| CEO| _____________ Value3
What I'd like to be able to do is consolidate those three rows into 1 row:
ID| Name| Title| Field1| Field2| Field3
01| Joey| CEO| Value1| Value2| Value3
Access does this easily via a query but I haven't found something similar in Excel via its own functionality. Is there such an animal? If not, some helpful code would be great.
Thanks in advance!
Ron
I've searched quite a few places and I'm sure that I'm not using the correct keywords because this shouldn't be difficult.
I have data that has the same "keys" (ID, Name, Title) but will have other columns that may or may not have a value. Below is an example of what I mean.
ID| Name| Title| Field1| Field2| Field3
01| Joey| CEO| Value1
01| Joey| CEO| _______ Value2
01| Joey| CEO| _____________ Value3
What I'd like to be able to do is consolidate those three rows into 1 row:
ID| Name| Title| Field1| Field2| Field3
01| Joey| CEO| Value1| Value2| Value3
Access does this easily via a query but I haven't found something similar in Excel via its own functionality. Is there such an animal? If not, some helpful code would be great.
Thanks in advance!
Ron
Last edited: