Move data from columns to row

Adrae

Active Member
Joined
Feb 19, 2002
Messages
306
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?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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.
 

Forum statistics

Threads
1,143,709
Messages
5,720,391
Members
422,283
Latest member
Parvathy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top