how do I combine rows into one row, besides copying and pasting?

B

Beth Daranciang

I have weekly data for study subjects, in separate rows in Excel. I want to
create one long row for each subject to prepare for SPSS analysis. I know I
could copy and paste, but wondered if there was an easier way to do it.
 
Y

YESHWANT JOSHI

Hi Beth Daranciang,

As i understand from your question, here is solution :
if u want to merge A1 to A5 in B1,
in B1 type "=A1&A2&A3&A4&A5" (WITHOUT QUOTES)

in case if u want space in between those lines,
in B1 type "=A1&" "&A2&" "&A3&" "&A4&" "&A5" (WITHOUT QUOTES)

add all those cells you want to merge in the above manner

clicke yes below, if it helps
 

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

Copy and pasting values of filtered rows 1
Combine rows to print on one label 2
Subdividing a Row into Multiple Rows 2
How To Combine Several Rows of Data into 1 Row of Data 3
Combine multiple rows into one. 2
Pasting text 1
Data: select a cell x rows below the current, where x is designate 1
Row height changes when copying and pasting 2

Top