One more request. The problem currently have about 150 lines and might increase higher on any given week. How do I place the data in another sheet called "data"?

Thanks,
Ty

On Saturday, February 8, 2014 12:11:16 PM UTC-6, Ty wrote:
I have a problem with data in a MS Excel spreadsheet in a column. I need 15 columns converted to rows. On the column I need the header to repeat for every item within that column.



problem:

column abc

row 222

row 333

row 444

row 555

row 1236

row 2bca



solution needed:

col-1/col-2 as headers rows all down below

abc 222

abc 333

abc 444

abc 555

abc 1236

abc 2bca



Any help will be greatly appreciated,

Ty