List content from row in columns if different from 0

**dordar** · 09-20-2011, 11:57 AM

Hi.

I have a sheet with either 0 or YEAR MONTH, and I want to list the values showing text and not the one with 0, and convert this row into a column.

Hoping for quick help :D

Thanks

David

**martindwilson** · 09-20-2011, 03:07 PM

???? is that along a row,what does it actually look like

**dordar** · 09-20-2011, 03:41 PM

It is from 2008-2012 each year with 12 months.

So 12 x 6 years = 72 colums..

If the month contains an error it displays example: 2012 DEC, which means that it is an error in year 2012 and month dec.

So the idea is to have a cover sheet where I we collect the errors, so that we can easily see if there is any errors in our system.

If no error the cell displays 0.

Thanks in advance

**martindwilson** · 09-20-2011, 05:34 PM

i simulated your data i wasn't sure if the dates on your example were real or not 2012 DEC ie if that is the result of formatting so i based it on the 0 values
so with a helper row results on sheet 2
note the helper could be on another sheet entirely in this example try cutting pasting it to sheet 3 for example,