M
miaparisian
Hi, I have data for several human subjects and their data is set up in
an excel file so that all the data for person 1 takes up 15 rows,
person 2 the next 15 rows, etc. I would like to make all of a single
person's data merged into one row horizontally, so that each human
subject has one row of data.
For example:
----------------------------------
001
a b c d e f g h
i j k l m
n o p q r s
t u v w x
y z
002
a b c d e f g h
i j k l m
....
----------------------------------
001 is the human subject number and each letter (datum) is in their own
cell. I would like it to read:
001 a b c d e f g h i j k l m n o p q r s t u v w x y z
002 a b c d ....
Is there a way I can do this keeping each letter in its own cell. I'm
not too experienced with Excel, so any step-by-step help would be
greatly appreciated.
Thanks
an excel file so that all the data for person 1 takes up 15 rows,
person 2 the next 15 rows, etc. I would like to make all of a single
person's data merged into one row horizontally, so that each human
subject has one row of data.
For example:
----------------------------------
001
a b c d e f g h
i j k l m
n o p q r s
t u v w x
y z
002
a b c d e f g h
i j k l m
....
----------------------------------
001 is the human subject number and each letter (datum) is in their own
cell. I would like it to read:
001 a b c d e f g h i j k l m n o p q r s t u v w x y z
002 a b c d ....
Is there a way I can do this keeping each letter in its own cell. I'm
not too experienced with Excel, so any step-by-step help would be
greatly appreciated.
Thanks