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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"willid" schrieb im Newsbeitrag
...
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.

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

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"willid" schrieb im Newsbeitrag
...
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.

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

"willid" wrote:

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.