combine 2 cells in column B based on same cell in column A

[jaybird304]

Ok So I used to be subscribed here through my old work email and then 2 years later after being laid off I am back to work but cannot get access to my last user but it appears to be purged anyway lol.

I have a spreadsheet, see below for sample, where some of my Claimant Names(Cell B) are multiple to the same TRS(Cell A). I need to have them all on one row. Example:

10N 15W 35	ANACONDA EXPLORATION LLC
10N 15W 35	SEARCHLIGHT EXPLORATION LLC

<tbody>
</tbody>

<tbody>
</tbody>

Should look like:

10N 15W 35 <tbody> </tbody>

ANACONDA EXPLORATION LLC, SEARCHLIGHT EXPLORATION LLC <tbody> </tbody>

<tbody>
</tbody>

Here is my sample:

TRS <tbody> </tbody>	Claimant Name <tbody> </tbody>
10N 13W 19 <tbody> </tbody>	CRISTOL ENTERPRISES LLC <tbody> </tbody>
10N 14W 24 <tbody> </tbody>	CRISTOL ENTERPRISES LLC <tbody> </tbody>
10N 14W 36 <tbody> </tbody>	GRE INC <tbody> </tbody>
10N 15W 34 <tbody> </tbody>	ANACONDA EXPLORATION LLC <tbody> </tbody>
10N 15W 35 <tbody> </tbody>	ANACONDA EXPLORATION LLC <tbody> </tbody>
10N 15W 35 <tbody> </tbody>	SEARCHLIGHT EXPLORATION LLC <tbody> </tbody>
10N 16W 33 <tbody> </tbody>	SPRUNGER MIKE <tbody> </tbody>
10N 17W 02 <tbody> </tbody>	KLF CHILDRENS TRUST <tbody> </tbody>
10N 17W 02 <tbody> </tbody>	KLF REVOC TRST <tbody> </tbody>
10N 17W 03 <tbody> </tbody>	KLF CHILDRENS TRUST <tbody> </tbody>

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 152.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

SEARCHLIGHT EXPLORATION LLC

<tbody>
</tbody>

</body>






























My spreadsheet is 6307 lines(including the blank rows where i would assume that the answer to the formula would be input).

Please help! Its been so long for me using formulas that I cannot figure this out!

Thanks in advance!!

 

[jaybird304]

Does anyone have any ideas? Can this even be done?