G
Guest
Hi. This seems so simple in my head, but I can't figure it out. I have a
sheet of data brought in from an access memo field. I've parsed the data
into rows, but it's mixed and I'm trying to get it into correct columns on a
separate sheet.
Example:
01D01 Comm. Date: 01/10/1967 Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970 Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982
I need, on the other sheet, Something like:
01D01 Comm. Date: 01/10/1967
Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970
Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982
so all commission dates are in one column, all manufacturers in another etc.
I was looking at vlookup across the row, or index or match, but can't figure
it out.
HELP!
sheet of data brought in from an access memo field. I've parsed the data
into rows, but it's mixed and I'm trying to get it into correct columns on a
separate sheet.
Example:
01D01 Comm. Date: 01/10/1967 Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970 Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982
I need, on the other sheet, Something like:
01D01 Comm. Date: 01/10/1967
Manufacturer: A.J. Riley
01D02 Comm. Date: 01/10/1970
Manufacturer: A.J. Riley
01D03 Serial Number: 12345 Comm. Date: 01/10/1982
so all commission dates are in one column, all manufacturers in another etc.
I was looking at vlookup across the row, or index or match, but can't figure
it out.
HELP!