merge fields across several columns

[gmeskil]

I have data that looks like this:

Column A Column B Column C
PT347-02010 Matrix 1901
(empty cell) Matrix 1902
(empty cell) Matrix 1911
(empty cell) Matrix 1912
(empty cell) Corolla 1801
(empty cell) Corolla 1802
(empty cell) Corolla 1811
(empty cell) Corolla 1812
PTS21-02030 Corolla 1801
(empty cell) Corolla 1802
(empty cell) Corolla 1811
(empty cell) Corolla 1812

and so on.
Column A is the actual part number. Column B is the vehicle that it fits and column C is the model code for that vehicle.
What I need to do is have the data come out like this.

PT347-02010 Matrix, Corolla 1901, 1902, 1911, 1912
PTS21-02030 Corolla 1801, 1802, 1811, 1812

I am sure that this will have to be done in several steps. Doing it by hand would take forever being that i have about 25,000 lines in the spreadsheet.

Greg

 

[rodp]

sorry? what is exactly it? err guessing here but have you just spotted the end result in columns Z:AN?!

I've not done the year thing though (2008,2009). Do you need that too? If so, please can you provide more examples as per post #17

Cheers

Rod

 

[gmeskil]

Did you just copy and paste my addition to lines 58 and 59?
I need my output data to look like what is on line 18 and 19 Z:AD

Greg

 

[rodp]

Hi Greg,

Yes that's right. Can you add another example of how you would want this to end up as:

PTS21-89040	4Runner
PTS21-89040	4Runner

<tbody>
[TD="align: right"]2008[/TD]
[TD="align: right"]8642[/TD]
[TD="align: right"]8646[/TD]
[TD="align: right"]8648[/TD]
[TD="align: right"]8664[/TD]
[TD="align: right"]8666[/TD]
[TD="align: right"]8668[/TD]
[TD="align: right"]8672[/TD]
[TD="align: right"]8676[/TD]
[TD="align: right"]8678[/TD]
[TD="align: right"]8682[/TD]
[TD="align: right"]8686[/TD]
[TD="align: right"]8688[/TD]

[TD="align: right"]2009[/TD]
[TD="align: right"]8642[/TD]
[TD="align: right"]8646[/TD]
[TD="align: right"]8648[/TD]
[TD="align: right"]8664[/TD]
[TD="align: right"]8666[/TD]
[TD="align: right"]8668[/TD]
[TD="align: right"]8672[/TD]
[TD="align: right"]8676[/TD]
[TD="align: right"]8678[/TD]
[TD="align: right"]8682[/TD]
[TD="align: right"]8686[/TD]
[TD="align: right"]8688[/TD]

</tbody>

and please could you then show me how you want to see it as if it was in a csv file re post #17 (the commas vs semicolon bit).

Thanks

Rodp

 

[gmeskil]

First off, when i save it as a text file it will be tab delimited.
secondly i need it to be exactly like what is shown in cells Z18 and Z19 through AD18 and AD19.
That way when i save it as a text file it will look like this.
PT347-02010 Corolla 2008, 2009 1901, 1902
PT347-02010 Matrix 2008, 2009 1911, 1912

is there any way we can speak on the phone? If so then you can call me @ 800-581-3033

Greg

<style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>

<colgroup><col style="width: 100px"><col width="64"><col width="105"><col width="31"><col width="31"></colgroup><tbody>
</tbody>

 

[rodp]

Hi Greg,

Might be a bit difficult as I'm based in the UK but we could organise a Skype call if required. However, I've made a change and got the years grouped together for you. Have a look at the range BC4:BP9 on the google sheeet

Hopefully this will do though.

Cheers

Rodp

 

[rodp]

Hi Greg,

Did you manage to take a look at the updated google spreadsheet?

Cheers

Rodp

 

[rodp]

Greg,

FYI, as you don't seem to be about I will assume that this is now ok and have changed the sharing to view only for the link you have provided on this site to ensure the solution doesn't get changed.

Let me know if this has worked for you.

Regards

Rodp