Hi, i have a list of values in one sheet that i want to be the header for another worksheets columns ie

Rows
Books
CD
Pens
Pencils
Paint

= columns
Books, CD, Pans, Pencils, Pain

thank you