Multiple values per unique identifier, but they need to be in 2 column chart

Hi all,

I've tried to search around for a solution to this issue but was having no luck in finding something that helped

I've got a list of unique identifiers in column A (1 thru 317). In columns B through I are numbers that are attributed to that identifier. There are not the same amount of numbers per identifier, though. What I need is to have this list into two columns. Below is a snippet of what the data looks like now

2015-07-08_1343.png

and I want it to look like this:
A B
1 3099464
1 2505326
1 2771306
2 480
2 3099559
2 3102721
2 549
2 397
2 309885
3 .....etc etc

If it is easier, I've attached the file to the thread.


If you need anything else let me know. Your help is greatly appreciated!

Perhaps something like this? Pls see the file in attachment

regards