Merge cells and remove duplicate rows

Hello,

I'm trying to set up a Macro which will take the following information:

Please Login or Register  to view this content.

...in columns A, B, C, D and E, and output the following:

Please Login or Register  to view this content.

...in columns A, B, C, D, E, F and G.

Any ideas how to go about doing this would be really appreciated!

Thanks,

Mark

Try this, which puts the results in sheet2.

Please Login or Register  to view this content.

Hello,

Thanks for the quick reply - the code you've provided works really well.

However, as the spreadsheet I am working on only has one tab (named 'ReportData') as it is automatically created from a piece of software, could you modify the Macro to overwrite the data rather than putting it into a separate worksheet?

Alternatively, could you include some code in the Macro to insert a new sheet before pasting the data across?

If you could indicate how this could be done, I'd appreciate it!

Thanks,

Mark

Mark - this will add a second sheet if not already there:

Please Login or Register  to view this content.