Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with merging a range of cells
I have a spreadsheet that is generated via a C# program. In the spreadsheet,
for example, column A will contain unit numbers. Each unit may have several products associated with it. So for example the spreadsheet will look like this. Unit # Team Leader Product Manufacturer 258 John Smith SONY 258 John Smith LG 258 John Smith MITSUBISHI 659 Chris Jones MAYTAG 659 Chris Jones KENMORE 659 Chris Jones AMANA 659 Chris Jones GE 8241 Sean White MOTOROLA 8241 Sean White SAMSUNG 8241 Sean White LG 8241 Sean White NOKIA My problem is that I am trying to merge a range of cells. I only want one unit number to show up and one team leader. So the spreadsheet would look like this instead......Can someone give me some pointers? Thanks! Unit # Team Leader Product Manufacturer 258 John Smith SONY LG MITSUBISHI 659 Chris Jones MAYTAG KENMORE AMANA GE 8241 Sean White MOTOROLA SAMSUNG LG NOKIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging cells and eliminating spaces for empty cells | Excel Discussion (Misc queries) | |||
Formula for merging cells/re sizing cells | Excel Discussion (Misc queries) | |||
merging cells together but keeping all data from the cells | Excel Discussion (Misc queries) | |||
Selecting and merging range within numerous rows | Excel Programming | |||
Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions |