Merge cells in a COLUMN when value is the same

[aprice]

I'm really, really new at this. In fact, I don't even understand the directions on how to post a sample of my data except to hope my copy/paste holds up. I can't figure out where to insert the Row/Column/Cell Range info as it pertains to my data when it is given as VBA as an answer to someone else's question. So, please be detailed and basic when you answer my question because I am trying really hard to learn.
Here's what I'm dealing with, sort-of:
[TABLE="width: 226"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Out
[/TD]
[TD]100[/TD]
[TD]6/11[/TD]
[TD]AP[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Out[/TD]
[TD]109[/TD]
[TD]6/01[/TD]
[TD]MR[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Out[/TD]
[TD]112[/TD]
[TD]5/24[/TD]
[TD]JC[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]In[/TD]
[TD]109[/TD]
[TD]5/30[/TD]
[TD]JC[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]In[/TD]
[TD]178[/TD]
[TD]6/11[/TD]
[TD]AP[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Lost[/TD]
[TD]100[/TD]
[TD]5/15[/TD]
[TD]AP[/TD]
[/TR]
</tbody>[/TABLE]

I want to merge A1-A3, then A4-A5, then A6-to how ever many would be below with the same text. This data goes on for about 150 rows. So, I don't want to have to select the duplicated cells in column A and merge them myself, like I have been doing.

I want it to look like this:
[TABLE="width: 226"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]100
[/TD]
[TD]6/11[/TD]
[TD]AP[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Out[/TD]
[TD]109
[/TD]
[TD]6/01[/TD]
[TD]MR[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]___[/TD]
[TD]112
[/TD]
[TD]5/24[/TD]
[TD]JC[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]In[/TD]
[TD]109
[/TD]
[TD]5/30[/TD]
[TD]JC[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]___[/TD]
[TD]178
[/TD]
[TD]6/11[/TD]
[TD]AP[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Lost
[/TD]
[TD]100
[/TD]
[TD]5/15[/TD]
[TD]AP[/TD]
[/TR]
</tbody>[/TABLE]


I hope that makes sense. I have been creating macros, and I have been stepping into the code to make minor alterations as I've come across things I need to correct in the macro, so I do have some basic knowledge of how it works, just not a lot.

 

[aprice]

Weirdly enough- I do not have a "Sharing & Privacy" button in my preferences. About half a dozen of my friends have tried to find it in preferences too. I don't have a Ribbon button. No one has been able to find it; it's not just me being clueless.
When I tried these in Excel, nothing happened.
or Function (fn) + Option (alt) + F11 to open the Editor windows
or Function + Option F8 to open the Macro window

I don't know why my Mac doesn't have the expected buttons or responses. They are probably just well hidden.

 

[Peter_SSs]

This worked PERFECTLY!!! Thank you so much.

Hopefully you meant my code from post #3.
In any case, it sounds like you have what you need.

 

[tygrrboi]

What version of excel is it? If it's too old, there's a chance you won't even be able to create macros.