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.

Assuming your data is in Sheet1, copy the 18 column headers from Sheet 1 to
A1:R1 on Sheet2 and then put this in Sheet2!A2 and copy across to Sheet2!R2 and
down as needed:

=SUMIF(Sheet1!$A$1:$IR$1,A$1,Sheet1!$A2:$IR2)

Select Sheet2 and Copy / Paste Special / Values. Then delete Sheet1.