Move data from columns to row

[Adrae]

I cuurently have data setup in the following format:

Columns:
A: Year
B: SS#
C: Dept#
D: Employee
E: Start Date
F: All Other
G: IS Pro
H: IS Dev

I want to take the information in columns F-H, or a selected range, and put them in rows only if the value in the cell is not zero. So if cell F5 has a value of .5, and G5 has a value of .5, and H5 is 0 then two rows will be created in a new workbook with columns A-E being the same, column F as the heading from F-G and column G as the value from the cell (.5)

Sound possible?

 

[MarkHenri]

Yes, with a macro.

 

[Steve Hartman]

On 2002-10-15 11:02, MarkHenri wrote:
Yes, with a macro.

Point proven once again.

http://216.92.17.166/board/viewtopic.php?topic=19494&forum=12&11
This message was edited by Steve Hartman on 2002-10-15 11:07

 

[Mark W.]

Yes, without a macro. Copy each column in turn and then Paste Special... Values Transpose to a separate row. Use AutoFilter to select those rows with zero values and delete those rows.