Find part data in row range?
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!
|