Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combine rows clms stay the same HELP
Customer Name 2000 sales 2001 Sales 2002 sales
Joe Smith $200.00 Joe Smith $300.00 Joe Smith $250.00 Kip Tucker $100.00 Kip Tucker $175.00 Kip Tucker $225.00 I need to combine these on to one row but leave them under the appropriate year and then delete the duplicate names Should look like this Customer Name 2000 sales 2001 Sales 2002 sales Joe Smith $200.00 $300.00 $250.00 Kip Tucker $100.00 $175.00 $225.00 |
#2
|
|||
|
|||
Your example shows a regular layout for all customers.
You could therefor simply lift the numbers in C column by one cell and in D column by two cells (using cut and paste) sort by B column to get writ of the empty lines and than resort the full lines by A column -- Greetings from New Zealand Bill K "bamamike" wrote in message oups.com... Customer Name 2000 sales 2001 Sales 2002 sales Joe Smith $200.00 Joe Smith $300.00 Joe Smith $250.00 Kip Tucker $100.00 Kip Tucker $175.00 Kip Tucker $225.00 I need to combine these on to one row but leave them under the appropriate year and then delete the duplicate names Should look like this Customer Name 2000 sales 2001 Sales 2002 sales Joe Smith $200.00 $300.00 $250.00 Kip Tucker $100.00 $175.00 $225.00 |
#3
|
|||
|
|||
See attachement, hope it helps. bamamike Wrote: Customer Name 2000 sales 2001 Sales 2002 sales Joe Smith $200.00 Joe Smith $300.00 Joe Smith $250.00 Kip Tucker $100.00 Kip Tucker $175.00 Kip Tucker $225.00 I need to combine these on to one row but leave them under the appropriate year and then delete the duplicate names Should look like this Customer Name 2000 sales 2001 Sales 2002 sales Joe Smith $200.00 $300.00 $250.00 Kip Tucker $100.00 $175.00 $225.00 +-------------------------------------------------------------------+ |Filename: Combine.zip | |Download: http://www.excelforum.com/attachment.php?postid=3838 | +-------------------------------------------------------------------+ -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=469006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link rows in Excel so they will stay together during sort? | Charts and Charting in Excel | |||
How do I group rows prior to a data sort so they stay together? | Excel Discussion (Misc queries) | |||
how to combine the multiple rows into one rows? | Excel Worksheet Functions | |||
rows and columns won't stay resized | Excel Worksheet Functions | |||
How do I combine rows, combining duplicates as well as concatenati | Excel Worksheet Functions |