rows of data - need to be filtered

  • Thread starter Thread starter Kenlyn
  • Start date Start date
K

Kenlyn

Below is my data:

row 1 name 1, add1, city1,
row 2 patient a
row 3 name 2, add 2, city 2
row 4 patient a
row 5 patient b
row 6 name 3, add 3, city 2
row 7 patient a

I need help getting the data to one row for each name1, name 2 - as
you can see name 2 has two patients -

My result data should look like:

row 1 name 1, add1, city1, patient a
row 2 name 2, add 2, city 2, patient a, patient b
row 3 name 3, add 3, city 2, patient a
I have tried filtering - but cannot get that to work my way..
suggestoins
(e-mail address removed) - Thanks.
 
First, maximum of two names per address????

If yes:
Name1 is in column A, add1 in B, city1 in C and patienta/b is in column A??

If yes, then I put this in D1:
=IF(B1="","deleteme",IF(B2="",A2,""))
and this in E1:
=IF(B1="","deleteme",IF(A3="","",IF(B3="",A3,"")))

And drag down.

Then copy C:D and edit|pastespecial|values.
apply Data|Filter|Autofilter to column C
Show just the "deleteme"
and delete those visible rows.
 
Dave -

With great thanks. That is awesome - I have been working on this for a
few days and I just couldn't see the light.

Thanks.

Kenlyn
 
Back
Top