Arrange the data by year and format.

[pesteness]

I would like you to show me what they are supposed to look like after being processed... that information will guide me in which approach to take in the code I write. Just so you know, I am not asking you what to do with those exact models, rather, I am more interested in their "structure" so I wil be able to decide on how to handle similarly "shaped" models.

in the actual file, the second sheet. that's i wanted to be the output.

[Rick Rothstein]

in the actual file, the second sheet. that's i wanted to be the output.

Sigh! I am not sure why you are "fighting" me on this (after all, you asked for the help). The items I asked you about were not covered in your sample data in the Actual File... that is why I asked you to show me what they should look like (remember, I am looking at the "structure" of those models and how you would actually handle them). I think you may be thinking this should be easier to write code for then it actually will be... while I think the code won't be too long, how you handle the 4 models I asked you about is critical to me in deciding on how to write that code.

[pesteness]

Sigh! I am not sure why you are "fighting" me on this (after all, you asked for the help). The items I asked you about were not covered in your sample data in the Actual File... that is why I asked you to show me what they should look like (remember, I am looking at the "structure" of those models and how you would actually handle them). I think you may be thinking this should be easier to write code for then it actually will be... while I think the code won't be too long, how you handle the 4 models I asked you about is critical to me in deciding on how to write that code.

no no. i'm not fighting with you why do i do that i'm the one asking for favor, i'm sorry i just dont really understand what you want.

[Rick Rothstein]

no no. i'm not fighting with you why do i do that i'm the one asking for favor, i'm sorry i just dont really understand what you want.

Make believe your MAIN FILE had only this in it...

Mercedes model - 300CE Coupe E Class 124.052 104.992 from 1993-1993
Mercedes model - 300E 3.2 E Class 124.032 104.992 from 1993-1993
Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986
Mercedes model - 300CD Turbo 123.153 617.952 from 1982-1983

What would the ACTUAL FILE for them look like?

[pesteness]

Make believe your MAIN FILE had only this in it...

Mercedes model - 300CE Coupe E Class 124.052 104.992 from 1993-1993
Mercedes model - 300E 3.2 E Class 124.032 104.992 from 1993-1993
Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986
Mercedes model - 300CD Turbo 123.153 617.952 from 1982-1983

What would the ACTUAL FILE for them look like?

I see, got it.

example this, Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986

this should be look like:

Make=Mercedes Model|Model=190E|Year=1984|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1985|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1986|Notes=2.3 201.024 102.98

the 2.3 comes with the notes

Thank you.

[Rick Rothstein]

I see, got it.

example this, Mercedes model - 190E 2.3 201.024 102.985 from 1984-1986

this should be look like:

Make=Mercedes Model|Model=190E|Year=1984|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1985|Notes=2.3 201.024 102.98
Make=Mercedes Model|Model=190E|Year=1986|Notes=2.3 201.024 102.98

the 2.3 comes with the notes

Thank you.

Okay, now what would the other three look like in the ACTUAL FILE (I do have a reason for asking about them also)?

[pesteness]

Okay, now what would the other three look like in the ACTUAL FILE (I do have a reason for asking about them also)?

yes, sure.

Make=Mercedes Model|Model=300CE Coupe E Class|Year=1993|Notes=124.052 104.992

Make=Mercedes Model|Model=300E E Class|Year=1993|Notes=124.032 104.992

Make=Mercedes Model|Model=300CD Turbo|Year=1982|Notes= 123.153 617.952
Make=Mercedes Model|Model=300CD Turbo|Year=1983|Notes= 123.153 617.952

just please disregard (3.2) the liters, i already know now what's your point.

Thanks,