jaybird304
New Member
- Joined
- Oct 19, 2017
- Messages
- 2
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:
<tbody>
</tbody>
<tbody>
</tbody>
Should look like:
<tbody>
</tbody>
Here is my sample:
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 152.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<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!!
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:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Here is my sample:
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<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>
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!!