Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transposing and creating new rows
I am dealing with a set of Excel 2002 worksheets organized in a standard
format in which each row represents a record for a single day and there are numerous variables recorded in columns. I need to transpose this to a format in which there is a single row for each non-zero occurence of each variable on each day, and the row needs to keep the date as its first-column entry. To illustrate, I need to change this: date1 v1 v2 v3 v4 date2 v1 v2 v3 v4... to this: date1 v1 date1 v2 date1 v3 date1 v4 date2 v1 date2 v2... This seems like a perfect task for a macro, but my macro literacy is insufficient to figure it out. Any suggestions geared toward a non-VBASIC -speaker would be greatly appreciated. Thanks in advance for any tips you can send my way. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing rows into columns | New Users to Excel | |||
Transposing *lots* of rows | Excel Discussion (Misc queries) | |||
Transposing columns to rows | Excel Discussion (Misc queries) | |||
Transposing a column to several rows | Excel Discussion (Misc queries) | |||
Transposing columns and rows | Excel Programming |