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