C
ceci
I have a sheet with 27,000 records, all of them have duplicate entries. Below
is a sample of what my records look like.
My data currently looks like this:
ID Name Fruit BC PC Date
1234 Smith Apple 09 B 12/05/05
1234 Simth Banana 04 12/05/05
This is what I want it to look like:
ID Name Fruit BC PC Date Fruit BC PC
Date
1234 Smith Apple 09 B 12/05/05 Banana 04
12/05/05
Some records might have up to 20 duplicate entries. I want to run a marco to
help me simplify things so I don't have to go through all 27,000 records
manually.
Thanks in advance for your help!
is a sample of what my records look like.
My data currently looks like this:
ID Name Fruit BC PC Date
1234 Smith Apple 09 B 12/05/05
1234 Simth Banana 04 12/05/05
This is what I want it to look like:
ID Name Fruit BC PC Date Fruit BC PC
Date
1234 Smith Apple 09 B 12/05/05 Banana 04
12/05/05
Some records might have up to 20 duplicate entries. I want to run a marco to
help me simplify things so I don't have to go through all 27,000 records
manually.
Thanks in advance for your help!