Transpose on Unique values

[Gdnspk]

Hi all,

I am new in here and this is my first post/query. I have a list of names with address and phones, the concern is the few names are duplicates which i need to remove but i would need their unique address and Phone number as address 2 and address 3 and Phone no 2 and phone number 3. The amount of duplicates can be as much as 100.

Thanks in advance.
Praveen Kumar

 

[NARAYANK991]

Hi Praveen ,

Unless you upload a workbook with enough data , a specific solution is difficult.

Suppose a name has 11 duplicates ; will all the 11 entries be unique as far as the address and phone numbers are concerned , or can there be duplicates within the addresses as well as phone numbers ? For example , could we have :

Name1 Address1 Phone1

Name1 Address1 Phone2

Name1 Address2 Phone2

Name1 Address2 Phone1

Narayan

 

[Gdnspk]

Hi Narayank,

Thanks for the reply the address and Phone number details might have duplicates as well, i dont want duplicates on those entries.

Thanks,
Praveen Kumar

 

[NARAYANK991]

Hi Praveen ,

Please give a specific answer to a specific question ; you mention that there can be duplicates ; I have given 4 cases ; in those 4 cases which would you want in the output , all 4 of them or only some of them ? If only some of them , then which of them , and what will be the logic to be used ?

Narayan

 

[Gdnspk]

Hi,

In the mentioned case, I will be in need of

Name1 address1 address2 Phone1 Phone2

Its just the database needs to updated with no duplicates in name and all their possible contact options.

Thanks,
Praveen Kumar

 

[NARAYANK991]

Hi Praveen ,

A formula solution is going to be difficult given the kind of variations possible ; for a VBA solution , please upload your file with enough data in it so that adequate testing can be done.

Narayan