Changing data from columns to rows?

[Hightechtoo]

I have a spreadsheet that has data in this format....

Name
Title
Company
Address
Address
Address
email

and I want to move it to row format.....

Name Title Company Address Address Address Email.

Is there an easy way to do this without cutting and pasting every darn field?

Thanks.

ron

 

[DonkeyOte]

is your data common repeated number of rows -- ie always same per entry ?

 

[Padawan]

hightechtoo

Welcome to the Board.

Try this:

Highlight your range.

Edit-> Copy

click on a single cell where you want the new range to start. I don't think you can click on the same cell as the original word "Name". If you need it there, paste to 1 column to the right, then delete the original column when done.

Edit->Paste Special Select All, and check Transpose.
Click OK.

That should do it.

Make sure you have a saved back up copy before you try this.

 

[Hightechtoo]

is your data common repeated number of rows -- ie always same per entry ?

Most all are the same.....a few have an additional address field....but If I can most of them done....I can manually do the few odd ones.....thanks...

 

[Hightechtoo]

Padawan......

Thanks....You saved me a ton of Time! That works great!

 

[DonkeyOte]

unfortunately if you don't have a common "range" it will be difficult...

could you provide say a list of 4 different entries -- preferably that show variation and where you have as you say one more row than normal... it might be possible but at the moment I'm not so sure...

presumably the data is in one column -- ie there are no *flags* in another column like

"Name:" in A1 and "Joe Bloggs" in B1 etc..

EDIT: resolved using padawan approach... had presumed data was a repetitive list of values as opposed to a multi dimensional range of values.

 

[Padawan]

Lasw10

Didn't intent to step on your response. We actually just cross-posted.

Best regards,