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:
<tbody>
</tbody>
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:
<tbody>
</tbody>
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.
Here's what I'm dealing with, sort-of:
| A | B | C | D | |
| 1 | Out | 100 | 6/11 | AP |
| 2 | Out | 109 | 6/01 | MR |
| 3 | Out | 112 | 5/24 | JC |
| 4 | In | 109 | 5/30 | JC |
| 5 | In | 178 | 6/11 | AP |
| 6 | Lost | 100 | 5/15 | AP |
<tbody>
</tbody>
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:
| A | B | C | D | |
| 1 | 100 | 6/11 | AP | |
| 2 | Out | 109 | 6/01 | MR |
| 3 | ___ | 112 | 5/24 | JC |
| 4 | In | 109 | 5/30 | JC |
| 5 | ___ | 178 | 6/11 | AP |
| 6 | Lost | 100 | 5/15 | AP |
<tbody>
</tbody>
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.
