Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find part data in row range?
What you are saying about what you have is not clear. What do you mean when
you say your data is "mixed"? Be very specific when you describe what you have. For instance: I have this in A1. I have this other in B1. etc. etc. I want this in A1. I want that in B1. etc. etc. HTH Otto "Fluke" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Add a data series dynamically to a named range? | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |