LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default need a macro to combine rows, columns

How do I go from this:
id name email zone 1 zone 2 zone 3
123 john dog
123 john
cat
456 mary
cat
789 sue
dog
789 sue
cat
789 sue
rabbit

To this:
id name email zone 1 zone 2 zone 3
123 john
dog cat
456 mary
cat
789 sue
dog cat rabbit

Thanks!
 
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
Not just remove dup rows but combine columns Colin Excel Worksheet Functions 1 January 14th 10 03:56 AM
Combine multiple columns and rows for one record into one row. Bowtie63 Excel Discussion (Misc queries) 2 February 16th 08 04:20 AM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 2 July 31st 06 09:45 PM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 0 July 31st 06 05:07 PM
Combine the data in 2 columns of 20 rows into one column of 40 row Tom Excel Discussion (Misc queries) 6 May 3rd 06 09:27 AM


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