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:
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]10N 15W 35[/TD]
[TD]ANACONDA EXPLORATION LLC[/TD]
[/TR]
[TR]
[TD]10N 15W 35[/TD]
[TD]SEARCHLIGHT EXPLORATION LLC[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 546"]
<tbody>[TR]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]


Should look like:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 15W 35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 357"]
<tbody>[TR]
[TD="width: 476"]ANACONDA EXPLORATION LLC, SEARCHLIGHT EXPLORATION LLC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Here is my sample:


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl65, width: 87"]TRS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 459"]
<tbody>[TR]
[TD="class: xl65, width: 459"]Claimant Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 13W 19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]CRISTOL ENTERPRISES LLC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 14W 24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]CRISTOL ENTERPRISES LLC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 14W 36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]GRE INC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 15W 34[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]ANACONDA EXPLORATION LLC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 15W 35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]ANACONDA EXPLORATION LLC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 15W 35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]SEARCHLIGHT EXPLORATION LLC[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 16W 33[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]SPRUNGER MIKE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 17W 02[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]KLF CHILDRENS TRUST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 17W 02[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]KLF REVOC TRST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="width: 87"]10N 17W 03[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 344"]
<tbody>[TR]
[TD="width: 459"]KLF CHILDRENS TRUST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

****** id="cke_pastebin" style="position: absolute; top: 152.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 546"]
<tbody>[TR]
[TD]SEARCHLIGHT EXPLORATION LLC[/TD]
[/TR]
</tbody>[/TABLE]
</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?