Is it possible to do this?

  • Thread starter Thread starter Mike Mike
  • Start date Start date
M

Mike Mike

Is it possible to move column B fields to the row with matching content in A

From this:

A B
bananas yellow
oranges candy
pigs bananas
cows blue
candy
blue
red
yellow

To this:

A B
bananas bananas
oranges
pigs
cows
candy candy
blue blue
red
yellow yellow


Regards
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can this be done? 1
Conditional Formatting where Matrix intersects 2
Copying information down a row that changes after new entries 1
Lookup?? 2
Access MS Access Help with Select Distinct(count field) 0
vlookup question - bring in all values? 6
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
How to determine the number of types? 5

Back
Top