Data extraction from two dimensional array

**Suzerain** · 07-31-2014, 01:54 PM

Hello everybody! Brand new user here with a problem.

2_2992220.JPG

If you'll look at the image, I have data in the above format. My question is how to best manipulate the data to arrive at the format you see at the bottom of the image.

Thanks for any help!

**Olly** · 07-31-2014, 04:45 PM

Your image is tiny, and tells us little.

Attach a workbook, and make your actual requirement clear.

**samba_ravi** · 08-01-2014, 01:59 AM

see the attached file

**AB33** · 08-01-2014, 04:23 AM

Try the attached.

**Olly** · 08-01-2014, 04:31 AM

Are you guys that have posted 'solutions' seeing a different picture to me? I can see a tiny crosstab in the attached JPG, but I can't see any output requirement. An I missing something, or are you assuming that's what the OP wants?

**AB33** · 08-01-2014, 04:39 AM

Oops,
I wrongly assumed that post #3 is posted by the OP. I have crystal ball eyes.

**apo** · 08-01-2014, 04:49 AM

@AB33... I downloaded that file thinking the same..

**mrkhchan** · 08-02-2014, 02:32 AM

Hi friend,
your file is very useful. but if the table contain blank row. Would you also have a way to process?
like:

nature Jul13 Aug 13
sales 15 18
other 11 20

cogs 10 6
tax 6 2

Many Thanks.