Hi I'm trying to find a way to make a small report from a sheet.


http://www.kulture.co.uk/excel


I'm not sure if PivotTables can be used or if I'd have to do something else but I basically need to sort of invert the information so for each number it would show which date, region and country are listed for that number.
For example it would display:

1 - 12th-Oct Munich, Germany
17th-Oct London, UK
20th-Oct Amsterdam, Netherlands
etc

2 - 06th-Oct Leeds, UK
12th-Oct Kingston, UK
20th-Oct Manchester, UK
etc


Is there a straightforward way of doing this?
Any help greatly appreciated!