how do i merge 2 rows of data into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Merging Cells and Sorting 1
freez issues need merge help 1
Merging data from 2 data excel sheets 2
Combine multiple rows into one. 2
Mail Merge Functionality 1

Back
Top