Newbie here...

Is there a way to import data from a MS Query "vertically" instead of
"horizontally?" I'm trying to import student names, month names, and
monthly grade average (for each student, sorted by name, and month).

Ex:

Name, Month, Avg
John Doe, Jan, 90
John Doe, Feb, 88
....
Jane Doe, 2003, Jan, 85
Jane Doe, 2003, Feb, 98

BUT, instead of having each student's monthly average placed in a row,
have it placed in columns with only one row/student. So:

Name, Jan (avg), Feb (avg), Mar (avg)...Dec (avg).
John Doe, 90,88...
Jane Doe, 85, 98...

I understand there will be problems with thus, such as some months
having no data. I'll hopefully figure that out later. I just need to
know if I need to design the query to do this somehow, or if I need to
write a macro to reorganize the data after the import.

Any help is appreciated!

One option could be - copy the range and chose paste
special and check transpose.
-----Original Message-----
Newbie here...

Is there a way to import data from a MS Query "vertically"
instead of
"horizontally?" I'm trying to import student names, month
names, and
monthly grade average (for each student, sorted by name,
and month).

Ex:

Name, Month, Avg
John Doe, Jan, 90
John Doe, Feb, 88
....
Jane Doe, 2003, Jan, 85
Jane Doe, 2003, Feb, 98

BUT, instead of having each student's monthly average
placed in a row,
have it placed in columns with only one row/student. So:

Name, Jan (avg), Feb (avg), Mar (avg)...Dec (avg).
John Doe, 90,88...
Jane Doe, 85, 98...

I understand there will be problems with thus, such as
some months
having no data. I'll hopefully figure that out later. I
just need to
know if I need to design the query to do this somehow, or
if I need to
write a macro to reorganize the data after the import.

Any help is appreciated!
.