Hi,

I have a requirement to bulid a macro, where I need to merge 2-3 columns data into one cell.

For example

Sheet 1

ID Report Summary
---- -------- ---------
101 ABC Description of ABC
102 EFG Description of EFG

I need a macro to combain ID +Report + Summary into one cell and it should continue for rest of the rows.
I need it in below format
-------------------------
101 ABC
Description of ABC
-------------------------
102 EFG
Description of EFG
------------------------
Regards
Kalyan