compress rows same ID

Hi Excel gurus,

I have a task I'm stuck on and need help please.

I have multiple rows with the same data up to a point i.e. columns A:J then the data changes from K:Q. if K:M has data then N:P will be empty and visa versa. So I'm looking for a way to compress the data into one row.

The ID will be the identifier and there are possibly thousands of rows of data each time.

If there are more than 2 records for credit no's then only one credit number record needs to be shown, doesn't matter which on so could be the earlier or latest. This is the same with the receipts. I have shown this in the attachment.

Hope the image is more clearer than my explanation.

Thanks

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Is there always only 2 entries per unique id...If not, then I suggest you upload a sample file with more than 2 showing expected result of this data merge...

Perhab like this

Please Login or Register  to view this content.

I am sorri i has update code should be dim v() or v() copy update code

sorry, just seen you message.

Or using collection

Please Login or Register  to view this content.

Same as with dictionary but
Any different little
Dictionaty easy for update and collection hard to update
Collection is more easy to write and read more than dictionary

Dont forget mak case as solved