IF, Transpose - Need Your Help!!

  • Thread starter Thread starter JRQ
  • Start date Start date
Attachments aren't welcoe in a non-binary newsgroup, and you haven't
given enough information in your message to hazard a guess.

Please post again with a detailed explanation of what you're trying
to do.


see http://cpearson.com/excel/newposte.htm for tips on using these newsgroups effectively.
 
IF, Transpose - Need Your Help!!
I need help with a formula.

I have a spreadsheet with keywords in column A and each keyword
corresponds to a URL in column B. I would like for the keywords that
have the same URL to all end up in the same row as just one of those
URLs.



I need all the keywords with the same URL to be transposed and lined
adjacent to a single URL.

example for final result looks like

A12:
http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp

B12: can, bag, elephant

Can anyone think of the right formula???? sample keywords and urls are
below

dog http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
cat http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
bird http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
apple http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
bear http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
lion http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
orange http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
green http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
red http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
can http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
bag http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
elephant http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
texas http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
longhorns http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
ut http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp
hook 'em http://www.;akjfdlfjkajflkd.com/ref...ource=excelhelp



__________________
 
Back
Top