Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Aligning with out cutting and pasting
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Aligning with out cutting and pasting
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting & pasting from one workbook to another | Excel Discussion (Misc queries) | |||
Cutting and Pasting with spaces | Excel Discussion (Misc queries) | |||
Cutting and Pasting in Excel | Excel Discussion (Misc queries) | |||
Data validation vs. cutting pasting | Excel Discussion (Misc queries) | |||
Formats when cutting and pasting | Excel Discussion (Misc queries) |