Merge same Records to One Row

[seenai]

Hi,
I have a database file with list of problems and action details for each problem.
The sample database and Requirements are given in the Excel File attached for ref.
Sample.xls
Please help me with a Suitable Macro.

[jindon]

Try the attached

[seenai]

HI,

Very nice for your help.

When I tested by increasing number of records, I am getting error to debug.
In my requirement, Both the number of rows and number of coolumns will be increased.

Please see the attached Excel Sample data (Sheet1) with more number of records. Sample1 With Code_.xls

I request your help. And it is OK, if the output data is generated in New Sheet.

Thank you.

[jindon]

Typo
change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[seenai]

Hi,

Please update macro as below :

In the Sample Data file attached,
a) the data indicated in RED should not appear (because, this is repeat data for the same Problem No.) &
i.e. for every 'Complaint No.' :- The consecutive duplicate datas to be made as only ONE data
b) the data to appear as a New Sheet.

Thanks in advance.Sample1 With Code_.xls

[jindon]

Is this the last change?

If there any possible change, tell us.

[seenai]

Hi,

This is the only requirement / last requirement.
Infact, Your is coding is really good.
But some communication gap. Sorry for troubling you.

Thanks again.

[Please Refer my Note in the First Excel file of my Request :
Only Point b) to be completed.
Macro Requirement :
a) select the ROWS with same PROBLEM No.
b) Remove Duplicate values in each Column
c) For Each Column, merge data from the rows in selection and puts each cell value on a new line.
d) Repeat for Next Problem No.

Note :The database is sorted based on Complaint No.]

[jindon]

Then I need a clear explanation.

121 has 2 01-Oct-12 (dups), where as 122 and 123 has no dups.

Why?

[seenai]

Hi,

You observation is right.
In 121 only ONE 01-Oct-12 is to be reported. (I missed to mark it as RED)
i.e. For every problem number, all consecutive duplicates are to be delected (in every column - for evry problem number)

[jindon]

Please Login or Register  to view this content.

[seenai]

Hi,

Sorry. The Macro is not running in Excel file.Sample1 With Code_.xls

[jindon]

..............

[seenai]

It's Really Great.
THANK YOU. It's a big Help to me.

[Solomon14all]

hi seenai,

Check whether this attachment solves your problem.

type the complain no in c2 then run.

Regards,

Raj.

[seenai]

Hi,

Thanks for your suggestion. the ex.xlsm is showng data with filter option.

My problem is solved by Mr.jindon, just now. Thanks.