Hi Guys!

I need help again... I don't really know how to explain it by words s
I'll be explaining what I need by examples... Hope you'll get what
mean...


For example I have the following data in Sheet2

DATE - NAME - SALES
8/1 - Paul - 10
8/1 - Gina - 23
8/1 - Lester - 65
8/1 - June - 12
8/1 - Lex - 8
8/2 - Paul - 6
8/2 - Gina - 1
8/2 - Ester - 4
8/3 - Paul - 8
8/3 - Gina - 5

How can I create a report in another sheet that something looks lik
this:

-----------------------------------------------------------|
NAME----------- |--- 8/1---- |--- 8/2----|--- 8/3----|
-----------------------------------------------------------|
Paul-------------|----10------|----6-------|----8------|
-----------------------------------------------------------
Gina-------------|-----23-----|-----1------|-----5-----|
-----------------------------------------------------------
so on and so forth...

Do you know how to do this without using Pivot?

I also attached here a sample of data... I have two sheets there.. th
Raw and Summary

Thanks for all the help!


Ar

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64731
--
Message posted from http://www.ExcelForum.com