odd or even rows......and importing from Access
 

Can't get Excel to accept data in odd or even rows........from outside
database.

Access has one line (row of data) and that can be copied into Excel, however
I would like to "split" some of that data between odd and even rows.
I can create queries to separate the data on right or left from Access -

example:
Person has one name but has two arms legs and ears.
I want the first colums in every row to contain the same name, but future
colums in those two rows to contain either right(odd) or left(even side
information.
ie;
row 1 Jones right ear good bad undetermined
row 2 Jones left ear good bad undetermined