Hi all, first time post so I hope I'm following the correct procedure
Was really hoping someone could give me guidance. Basically I have a file as per the information below and I need to merge Column2 and Column3 - but based on the value in Column 1.
<tbody>
</tbody>
So in the past I've done a CONCATENATE formula for each PARTNO in Column 1, but I now have significantly more part numbers and it's way too time consuming to do them all in one.
Basically the finished file needs to look like this:
<tbody>
</tbody>
What's important to mention with this is that if the Car Make in Column 2 is different, it then includes the next unique Car Make from Column 2 as long as it's associated with the PARTNO in Column A.
However, I also don't mind if it looks like this with the next unique car make on a second line.
<tbody>
</tbody>
Hope this has been explained well and appreciate any feedback to guide me along the way
Was really hoping someone could give me guidance. Basically I have a file as per the information below and I need to merge Column2 and Column3 - but based on the value in Column 1.
PARTNO1 | Hyundai | Accent |
PARTNO1 | Hyundai | i30 |
PARTNO1 | Hyundai | i40 |
PARTNO2 | Hyundai | Accent |
PARTNO2 | Subaru | Impreza |
PARTNO2 | Toyota | Celica |
PARTNO3 | Toyota | Celica |
PARTNO3 | Toyota | MR2 |
<tbody>
</tbody>
So in the past I've done a CONCATENATE formula for each PARTNO in Column 1, but I now have significantly more part numbers and it's way too time consuming to do them all in one.
Basically the finished file needs to look like this:
PARTNO1 | Hyundai Accent, i30, i40 |
PARTNO2 | Hyundai Accent, Subaru Impreza, Toyota Celica |
PARTNO3 | Toyota Celica, MR2 |
<tbody>
</tbody>
What's important to mention with this is that if the Car Make in Column 2 is different, it then includes the next unique Car Make from Column 2 as long as it's associated with the PARTNO in Column A.
However, I also don't mind if it looks like this with the next unique car make on a second line.
PARTNO1 | Hyundai Accent, i30, i40 |
PARTNO2 | Hyundai Accent |
PARTNO2 | Subaru Impreza |
PARTNO2 | Toyota Celica |
PARTNO3 | Toyota Celica, MR2 |
<tbody>
</tbody>
Hope this has been explained well and appreciate any feedback to guide me along the way