how do i merge 2 rows of data into one

W

willid

I am trying to combine data from 2 rows so that i can use the data as one row
which will enable me to sort the data accordingly.
 
F

Frank Kabel

Hi
you may provide some more details how your data is structured and how
you want to combine it
 
P

Peo Sjoblom

You can't merge data without losing parts of it, you can use a help row,
insert a help row below the 2 rows you want to "merge", then use

=A1&A2

copy across as long as needed, while selected copy and paste special as
values in place, then delete the 2 original rows

Regards,

Peo Sjoblom
 
W

willid

i have a worksheet of patient data, each patient has 2 rows of data and i
need to combine the 2 rows into one.Many thanks
 
Top