How can I transfer CrossTab to origial format?

[amolin]

For example:

I want to transform this table

Name Jan Feb Mar Apr ...................
David 5 6 8 5

to

Name Month Number
David Jan 5
David Feb 6
David Mar 8
David Apr 5
.
.
.
.
Can I do this by query?

 

[Jon K]

You can do it with a UNION query.

However, to sort the months properly, you will need a second query to join the UNION query with a SortOrder table. See database attached.
.

 

[amolin]

You can do it with a UNION query.

However, to sort the months properly, you will need a second query to join the UNION query with a SortOrder table. See database attached.
.

Thank you !

But if the column number of crosstab is not fixed ,how can I do?

By the way,I don't need sorting in result table .



Thank you again..

 

[Jon K]

If the column number is not fixed, you will need to use VBA to loop through the fields
to dynamically build the UNION query or
to directly put the data into a temporary table.

 

[amolin]

If the column number is not fixed, you will need to use VBA to loop through the fields
to dynamically build the UNION query or
to directly put the data into a temporary table.

I see,Thank you!