Q: How to import data "vertically"
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!
.
|