Any ideas on the following would be much appreciated.

I have an excel spread sheet listing locations in one column and a list of cities in another column. Using crystal I need to produce a report that shows for each location a row for the location and each city.

e.g.

Hotel 1 New York
Hotel 1 Boston
Hotel 1 Chicago

Hotel 2 New York
Hotel 2 Boston
Hotel 3 Chicago

Any ideas of how I can do this?

Edited by RoadRunner - 08 Jun 2015 at 1:09am