Is there a way to do reversal way as CrossTab query

[weekend00]

As we know, CrossTab query transform a vertical table into horizonal one,
Is there a query to do the reverse way, to convert a horizonal table to vertical one?



For example:
Table tbl

F1 P1 P2 P3
a 0.1 0.2 0.3
b 0.2 0.1 0.3

convert to:

F1 Ps VV
a p1 0.1
a p2 0.2
a p3 0.3
b p1 0.2
b p2 0.1
b p3 0.3

I would like one query to do this, not a bunch of VBA codes or a union of queries.

[pkstormy]

Wouldn't you just make it a simple select query?

[weekend00]

Just forget it.
base on my research on internet, union query and VBA coding is the only 2 ways to do that.

So I just mark it as solved.