Reversed Crosstab Query?

G’day all :D

I was wondering if there was a way to setup a Reversed Crosstab query:confused: . I am running a query which is pulling data from an import table. But the one thing is the data that I import is already setup like a Crosstab. Ex:

First Name, Last Name, Employee ID,Value 1,Value 2,Value 3,
Joe, Smith,38689, 4,2,8,
Bob, Smith,38957, 7,3,2,
Matt, Jones,38745, 4,7,7,
Jill, Brown,38467, 6,4,3,
Joan, Miller, 38058, 8,9,6,

I tried to setup multiple queries for each value then tried to pull it all into one query, but then I get all records multiplied 5 times.:eek:

Basicly I need the following results:
First Name,Last Name,Employee ID,Value,Number,
Joe, Smith, 38689, 1,4,
Joe, Smith, 38689, 2,2,
Joe, Smith, 38689, 3,8,
Bob, Smith, 38957, 1,7,
Bob, Smith, 38957, 2,3,
Bob, Smith, 38957, 3,2,
Matt, Jones, 38745, 1,4,
Matt, Jones, 38745, 2,7,
Matt, Jones, 38745, 3,7,
Jill, Brown, 38467, 1,6,
Jill, Brown, 38467, 2,4,
Jill, Brown, 38467, 3,3,

Anyone thing that will help, I will be very grateful,
Thanks in advance

Mur