Data Aligning with out cutting and pasting

[Earl Tewksbury]

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.

 

[Sean Timmons]

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.

 

[Glenn]

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.