need help!! sort multiple rows into single column

Hi,

I am using excel 2010 and windows.
can anyone help translate using VBA code.
thank you.

here is some example data
description header1 header2 header3 header4 header5
test 2 8 9 69 47
trial 1 5 99 102 1010
fry 3 5 4 7 10

result that I want is
Description value
trial 1
test 2
fry 3
fry 4
fry 5
trial 5
fry 7
test 8
test 9
fry 10
test 47
test 69
trial 99
trial 102
trial 1010

You could use this code that read data in the first sheet and copy and sort them in the second sheet:

Please Login or Register  to view this content.

Regards,
Antonio

Assuming header starts from A1 and no blank row(s)/column(s) in data range.

Please Login or Register  to view this content.

thanks both of you for your helps.

both code are working and really appreciate it.