Collecting contents of several cells into a single cell

[Nickjon]

Hi,

I have to collect contents of several cells in a row into a single cell in the same row. And I have to do it for thousands of rows, which is obviosly pretty a mundane job to do. Therefore I wanted to do it through some macros.
While copying a content of a cell, the header of the corresponding cell's column should be added before the content of the cell. You can see it below in cell D7. Some of the cells are empty and they should be skipped.
I have to collect the contents of columns from E to J into column D.
I would be very grateful if someone could help me out with this. Many thanks!
Nick


-- removed inline image ---

 

[mikerickson]

Your image is not coming through.

"for thousands of rows...when copying the contents of a cell, the header..should be added before the content of the cell"

I'm not sure what you want, but there is a 255 limit to the number of characters that a cell will show.

But you might want to look at the ConcatIf UDF.http://www.mrexcel.com/forum/showthread.php?t=566842&highlight=ConcatIf

 

[Nickjon]

Thanks for the reply. I am trying to upload the picture one more time:

 

[Nickjon]

Somehow I haven't been able to upload the picture here. But I have the link for it:
http://tinypic.com/r/10nx5ae/7