How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!

Without a macro..........

DataFilterAdvanced Filter

Copy to another location.

Unique records only.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:46:01 -0700, mrsjcd3
wrote:

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!

But that takes away the second or third rows that have different information
in the columns...

"Gord Dibben" wrote:

Without a macro..........

DataFilterAdvanced Filter

Copy to another location.

Unique records only.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:46:01 -0700, mrsjcd3
wrote:

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!

the advanced filter only hides those rows since they don't match the criteria.
By copying only the visible rows to a new sheet, your requirement is answered.
Seems your question may need to be re-phrased perhaps?

"mrsjcd3" wrote:

But that takes away the second or third rows that have different information
in the columns...

"Gord Dibben" wrote:

Without a macro..........

DataFilterAdvanced Filter

Copy to another location.

Unique records only.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:46:01 -0700, mrsjcd3
wrote:

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!

What I need to do it to combine the different columnal information for the
same person which is currently in multiple rows, in to one row for that
person. I am not filtering, I am combining. I was hoping not to have to
cut, paste and delete 6000+ rows of data to condense it down to 3500 rows.
In my example, id # 123 has two rows, but each row has different columnal
information. I need to have all that data in one row. If I filter, I lose
the second or third row of information which I wanted to combine in to the
first row.
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit




"Patrick Molloy" wrote:

the advanced filter only hides those rows since they don't match the criteria.
By copying only the visible rows to a new sheet, your requirement is answered.
Seems your question may need to be re-phrased perhaps?

"mrsjcd3" wrote:

But that takes away the second or third rows that have different information
in the columns...

"Gord Dibben" wrote:

Without a macro..........

DataFilterAdvanced Filter

Copy to another location.

Unique records only.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:46:01 -0700, mrsjcd3
wrote:

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!

Sub Main()
Dim col As Long
Dim thisrow As Long
Range("A1").CurrentRegion.Sort Range("A1")

For thisrow = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(thisrow, 1) = Cells(thisrow - 1, 1) Then
For col = 4 To Cells(thisrow, Columns.Count).End(xlToLeft).Column
Cells(thisrow - 1, Columns.Count).End(xlToLeft).Offset(, 1) = _

Cells(thisrow, col)
Next
Rows(thisrow).Delete
End If
Next



End Sub

"mrsjcd3" wrote:

What I need to do it to combine the different columnal information for the
same person which is currently in multiple rows, in to one row for that
person. I am not filtering, I am combining. I was hoping not to have to
cut, paste and delete 6000+ rows of data to condense it down to 3500 rows.
In my example, id # 123 has two rows, but each row has different columnal
information. I need to have all that data in one row. If I filter, I lose
the second or third row of information which I wanted to combine in to the
first row.
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit




"Patrick Molloy" wrote:

the advanced filter only hides those rows since they don't match the criteria.
By copying only the visible rows to a new sheet, your requirement is answered.
Seems your question may need to be re-phrased perhaps?

"mrsjcd3" wrote:

But that takes away the second or third rows that have different information
in the columns...

"Gord Dibben" wrote:

Without a macro..........

DataFilterAdvanced Filter

Copy to another location.

Unique records only.


Gord Dibben MS Excel MVP

On Tue, 15 Sep 2009 12:46:01 -0700, mrsjcd3
wrote:

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john cat
456 mary cat
789 sue dog
789 sue cat
789 sue rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john dog cat
456 mary cat
789 sue dog cat rabbit

Thanks!