LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i automatically move data from rows to columns? iainmac Excel Discussion (Misc queries) 1 April 16th 07 03:16 PM
Pulling data from multiple rows and columns Mark C Excel Worksheet Functions 3 February 25th 07 08:33 AM
how do I move data in prexisting rows to columns? darryl Excel Worksheet Functions 1 July 15th 06 10:08 AM
Move multiple rows of data that are not sequential Mel Excel Discussion (Misc queries) 1 January 20th 06 06:33 AM
Move Data from rows to columns... Dan B Excel Worksheet Functions 2 January 6th 06 04:47 PM


All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"