Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to join row data into one row

I have many columns of names. The data is sorted out into the following
columns: First, Last, Address, City, State, Zip.

John Doe 1234 E Street Los Angeles CA 12345
Jane Doe 1234 E Street Los Angeles CA 12345
Bob Smith 4321 Tree Ave Denver CO 54321
Joe Johnson 987 North Lane Philadelphia PA 65432
Sue Johnson 987 North Lane Philadelphia PA 65432
Lisa Johnson 987 North Lane Philadelphia PA 65432

I want to combine John & Jane Doe into one row, Joe, Sue & Lisa Johnson into
one row, etc.

what can I do to look at the addresses, see if they're the same, look at
last names, see if they're the same, then combine first names into one row
with the appropriate last name and address info?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default How to join row data into one row

Using Excel 2007 and Tables:
http://www.savefile.com/files/1882423
Reply
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
Join tables like inner join in Access ryanp Excel Discussion (Misc queries) 2 July 18th 08 04:35 PM
join text RKS Excel Discussion (Misc queries) 7 April 15th 08 04:43 AM
Merge /Join data Kevin R Excel Discussion (Misc queries) 2 March 23rd 07 12:32 AM
Join text Robert57 Excel Discussion (Misc queries) 7 December 22nd 05 04:14 PM
join two spreadsheets Raya Excel Discussion (Misc queries) 1 July 14th 05 03:13 PM


All times are GMT +1. The time now is 09:31 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"