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!!!!!!