Converting data

[Nick Anderson]

Hi,

I have a report that is designed in this format

Date: 3/31/2008 to 4/1/2008

Burger King
Sales
John 10,000
Mary 5,000
Frank 0
Lyle 250

Burger King
Hours
John 50
Mary 25
Frank 0
Lyle 10

As you can see I have a bunch of data in one column in the workbook. What I
need to do is take all of the names, John, Mary, Frank, and Lyle and list
them like this.

John Sales 10,000
John Hours 50
Mary Sales 5,000
Mary Hours 25
Frank Sales 0
Frank Hours 0
Lyle Sales 250
Lyle Hours 10

or like this

Name Sales Hour
John 10,000 50
Mary 5,000 25
Frank 0 0
Lyle 250 10

Does anyone have any suggestions to make this easy?

Thanks
Nick

 

[aaron_kempf]

put it into a fact table and get to know a real ETL tool.

If you need to know about 'fact tables' then I would reccomend picking
up a book by Ralph Kimball.

Thanks & Good Luck

-Aaron

 

[Gina Whipp]

Nick,

Sounds like you are in Excel, if this is true try posting to
microsoft.public.excel newsgroup. If this is not true, your table structure
would help to get a solution.