need help....lookup/index/anything

**Jhon Mustofa** · 08-26-2013, 02:37 AM

hii all

somebody can help me???

i attach my table...

thank

**Fotis1991** · 08-26-2013, 02:49 AM

Hi

You have this table.

Please Login or Register  to view this content.

Expected results.

Please Login or Register  to view this content.

Why(for example) bill has under code 1, two results? In your first table has only one. "aa1" . ab1 is under code 2 in your original table.

**Jhon Mustofa** · 08-26-2013, 02:57 AM

all value under column code1, like transpose column to rows..

**ramananhrm** · 08-26-2013, 03:32 AM

Please try this file.

**Jhon Mustofa** · 08-26-2013, 03:47 AM

great answer, ramananhrm...

thank

Re: need help....lookup/index/anything