Verticle to Horizontal

[Figboot]

I have a verticle list (attached) of locations and dates. Some locations have more than one date. I want to be able to show each location and all dates that show up on the original list.

List:
Location 1 - 1/15
Location 2 - 1/18
Location 1 - 2/15

To look like this:
Location 1 1/15 2/15
Location 2 1/18

Thanks!

[NBVC]

Assuming you have a unique list of locations starting in A12. (if you don't you can use Data|Sort and Filter|Advanced to create one).

Then in B12 apply formula:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copy across as far as needed and down.

[Figboot]

Perfect! Thank you very much.