move data that occupies multiple rows/columns into one row
 

I have data that looks like this:

company name title
address city state zip

each piece of data occupys it's own cell

I would like to copy the data so it looks like this
company name title address city state zip

so the data all appears in one row.

Thank you for your help!

move data that occupies multiple rows/columns into one row
 

Concatenate it
If the data started in A1 and went to G1 it would look like

=A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1

And you can put anything between the " ", so if you wanted a comma to
separate some values then put &", ". The parenthesis add a space between the
vallues, without them you will have just 1 long line of text.

"LizE" wrote:

I have data that looks like this:

company name title
address city state zip

each piece of data occupys it's own cell

I would like to copy the data so it looks like this
company name title address city state zip

so the data all appears in one row.

Thank you for your help!

move data that occupies multiple rows/columns into one row
 

thanks - that worked just fine!!!

"akphidelt" wrote:

Concatenate it
If the data started in A1 and went to G1 it would look like

=A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1

And you can put anything between the " ", so if you wanted a comma to
separate some values then put &", ". The parenthesis add a space between the
vallues, without them you will have just 1 long line of text.

"LizE" wrote:

I have data that looks like this:

company name title
address city state zip

each piece of data occupys it's own cell

I would like to copy the data so it looks like this
company name title address city state zip

so the data all appears in one row.

Thank you for your help!

move data that occupies multiple rows/columns into one row
 

You sure you wanted everything in one cell?

Will make for problems later when sorting or filtering or using for address
labels.

I would use a formula to place the 6 entries in 6 cells.

=OFFSET($A2;(COLUMN()-1)/3;MOD(COLUMN()-1;3))

Assuming data is in A2:C3, enter the formula in A1 and drag across.


Gord Dibben MS Excel MVP

On Wed, 16 Apr 2008 11:34:00 -0700, LizE wrote:

thanks - that worked just fine!!!

"akphidelt" wrote:

Concatenate it
If the data started in A1 and went to G1 it would look like

=A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1

And you can put anything between the " ", so if you wanted a comma to
separate some values then put &", ". The parenthesis add a space between the
vallues, without them you will have just 1 long line of text.

"LizE" wrote:

I have data that looks like this:

company name title
address city state zip

each piece of data occupys it's own cell

I would like to copy the data so it looks like this
company name title address city state zip

so the data all appears in one row.

Thank you for your help!

actually i have data on my notepad with comma bt when i m putting this in excel sheet it is cuming in a single row or column I want to put after comma data into next row

how can i do this?
plz help me out.

Thanks & regards
Shereen Siddiqui

Good day guys,

I've got a senario where I need to move contents in multiple cells to one cell. But I'm talking about 2000 lines.

It look something like the following:

Product code - Price - Description

So what basicaly hapens is, the description of the product get so long sometimes that it get put in 4 rows underneath each other

So what I need is to get each product in it's own line and not in multiple rows as I received it in.

Can somebody plzzzzzzzzz help me??

Regards