Convert Table to List

I have a table display this way:-

XS S M L XL 2XL 3XL
DG6547 100 200 300 400 500 600 700
DG6548 100 200 300 400 500 600 700
DG6549 100 200 300 400 500 600 700

How do i convert them into listing with code combine?

DG6547 XS 100
DG6547 S 200
DG6547 M 300
DG6547 L 400
DG6547 XL 500
DG6547 2XL 600
DG6547 3XL 700
DG6548 XS 100
DG6548 S 200
DG6548 M 300
DG6548 L 400
DG6548 XL 500
DG6548 2XL 600
DG6548 3XL 700


Thank you.

Joanne

I was prompt with a message "How many colums are fixed?"
How do i solve this?

Joanne

It work perfectly, thank you so much!