transposing data
 

the sheet i am working with has row headings, not column headings. so to
create pivot tables, i am forced to make a new sheet with the transpose of
the data. this way, there are recognizable column headings. is there a away
to automate this so when new data is entered, i don't have to highlight the
data, copy the transpose to a new sheet, then create the pivot tables?

thanks in advance
steve