Copying contents of several cells into single cell

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

I would just use a formula like this starting at D7 and filling down:

Please Login or Register  to view this content.

For future reference, it would be much easier to work with if you'd post your actual workbook. If there are additional columns you need to check, just add them to the formula. I'd have done it for you, but I have no idea how far over you need to examine since all I got was a screenshot...

Regards,
Tom

Try this in D4

Please Login or Register  to view this content.

Drag/Fill Down

Done. See attached.

Re Post #5

It's a worksheet formula, read the post, it goes in D4 in the worksheet.
then use the Fill Handle to drag it down to the end of your data.

However, seems you want a macro try this in a standard module

Please Login or Register  to view this content.

Hope this helps.