Convert data in multiple columns to single column

Any ideas how I can convert a table like this (with about 100 columns in real data, this is just a sample):
Acct# 3900492 3910034 3919576 3929118 3938660 3948202 3957744
1 5 2 1 1 4 0 2
4 11 3 3 0 26 0 8
55 10 5 5 4 10 0 10
56 0 0 0 0 0 0 0
83 0 0 0 0 0 9 14
105 1 0 0 0 1 0 0
127 0 0 0 0 0 0 0
155 0 0 0 0 0 0 0
170 111 695 245 461 487 215 510
192 0 0 0 0 9 0 9

to have just one column for the Acct# and the item number in column B (currently column headings) and quantities in columns C, like this:

Acct# Item # Qty
1 3900492 5
4 3900492 11
55 3900492 10
56 3900492 0
83 3900492 0
105 3900492 1
127 3900492 0
155 3900492 0
170 3900492 111
192 3900492 0
1 3910034 2
4 3910034 3
55 3910034 5
56 3910034 0
83 3910034 0
105 3910034 0
127 3910034 0
155 3910034 0
170 3910034 695
192 3910034 0

Too risky to just copy and paste.

Thanks!!!!!!

Sorry that came out so ugly, this is new for me.

Test.xls

Pl see the attached file.The macro transfers the data from the activesheet to sheet2 in the required form.
The Sheet name can be changed according to requuirement.
Any clarifications welcome.

PERFECT!! Thank you.