Create List from a table of data

[Guest]

How do I create a (3 column) list from a table of data? Column A has part numbers, Row 1 has vendors
Original data looks like
vend a vend
part a 10 2
part b 15 2
part c 17 2

I want it to convert to

part a vend a 1
part a vend b 2
part b vend a 1
part b vend b 2
part c vend a 1
part c vend b 2

 

[Andy B]

Hi

If I was doing it, I'd probably use a quick and dirty method:
Copy columns A and B onto a fresh sheet, insert a column in between and fill
it down with vend a
Go back to your original sheet and move column b out of the way. Do the same
as above with Column A and the new column B, and then fill down the middle
with vend b on the new sheet.
You can then sort on column a, if required, to get the list you have posted.

Hope this helps