Create a new sheet if column/row contains value then copy row

[beerworks]

I'm not having much luck in trying to get figured out.

I have a sheet that has 12 months on separate columns as well as other data, I would like to create a new sheet that takes the dates and copy with all the data it to from a line if the date column/row has a non zero value.

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

Book1
	A	B	C	D	E	F	G	H	I	J
1	Id	Desc	Head1	Head2		Jan-18	Feb-18	Mar-18		Dec-18
2	12123	line 1	qq1	aa1		100	60	0		20
3	12222	line 2	ww2	ss2		20	10	20		0
4
5	23123	line 3	ee3	dd3		0	50	0		10
6
7	Transform to this
8
9	Date	Id	Desc	Head1	Head2		Qty
10	Jan-18	12123	line 1	qq1	aa1		100
11	Jan-18	12222	line 2	ww2	ss2		20
12	Feb-18	12123	line 1	qq1	aa1		69
13	Feb-18	12222	line 2	ww2	ss2		10
14	Feb-18	23123	line 3	ee3	dd3		50
15
16	Dec-18	12123	line 1	qq1	aa1		20
17	Dec-18	23123	line 3	ee3	dd3		10
Sheet1

 

[hiker95]

beerworks,

Welcome to the MrExcel forum.

In order to assist you, it would help is we could see all of your actual raw data workbook/worksheets, with the raw data in Sheet1, and, the results (manually formatted by you for the results that you are looking for) in another worksheet.


You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com