View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Earl Tewksbury Earl Tewksbury is offline
external usenet poster
 
Posts: 1
Default Data Aligning with out cutting and pasting

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.