so all of the headers are the same? Just highlight your columns,
data-filter-Autofilter, click (custom...) in the first column, make equals
and give the name of the header.

Then, from the 2nd row, highlight the row numbers to bottm.. edit-delete.

"Earl Tewksbury" wrote:

Hi,

I have 14 sets of 18 columns of data, 252 columns of data. Each set of 18
has repeating column tittles in row1. I need to compile all of the columns
of data into to the first 18 columns (A - R) and remove all tittles except
for whats in row1. Is there an easier way to do this than just cutting and
pasting? Thanks.