Concatenation question
 

I would like to automate the process of concatenating one of my
columns based on what is in the starting row:

Example of what I have:

| A | B | C | D | E |
1 | X

Concatenation question
 

(Sorry, I seem to have lost control of the LEM.)

I would like to create a macro that would automatically concatenate
the data in E based on the starting row and end at the next starting
row.

Here is what I have:


| A | B | C | D | E |
1 | T | X | X | X | H |
2 | | | | | E |
3 | | | | | L |
4 | | | | | L |
5 | | | | | O |
6 | M | X | X | X | H |
7 | | | | | E |
8 | | | | | L |
9 | | | | | L |
10 | | | | | O |

What I would like it to do:

| A | B | C | D | E |
1 | T | X | X | X | HELLO |
2 | | | | | |
3 | | | | | |
4 | | | | | |
5 | | | | | |
6 | M | X | X | X | HELLO |
7 | | | | | |
8 | | | | | |
9 | | | | | |
10 | | | | | |


I already have a tiny macro that will concatenate based on selection,
but doing it over and over can become tedious. I would like to select
the whole sheet, start the macro and have it do the above.

Any suggestions?