Consolidating Redundant Text
 

My issue:

I've a worksheet with 17 columns of data.
Total is roughly 10,000 rows.

Of those 10,000 rows, I am dealing with roughly 1000 different items.

That being the case, each item has roughly 10 rows, where the first 15 of 17
pieces of data are identical.

For strictly aesthetic purposes, I would like to have the redundant text
appear only once.

Simple illustration - and I apologize ahead of time - I know the formatting
won't look right, but I'm hoping you'll get the idea.

BEFORE

Joe West Div Sales Dept 1
Joe West Div Sales Dept 2
Joe West Div Sales Dept 3
Joe West Div Sales Dept 4
Fred East Marketing 132
Fred East Marketing 332
Fred East Marketing 423
Fred East Marketing 428

What I would like it to look like:

Joe West Div Sales Dept 1
2
3
4
Fred East Marketing 132
332
423
428

I've an idea I might be able to do this with a pivot, but I'm not sure and
don't know how.
I've an idea maybe I could do this with consolidate, but I'm not sure and
don't know how.


Any help would be greatly appreciated.

Thanks in advance!
Brad

Consolidating Redundant Text
 

You could try conditional formatting so that if a cell= the cell above it
(A2=A3) the font changes to white. This would clean up the visual, but leave
the data intact.
--
If this helps, please remember to click yes.


"Brad Autry" wrote:

My issue:

I've a worksheet with 17 columns of data.
Total is roughly 10,000 rows.

Of those 10,000 rows, I am dealing with roughly 1000 different items.

That being the case, each item has roughly 10 rows, where the first 15 of 17
pieces of data are identical.

For strictly aesthetic purposes, I would like to have the redundant text
appear only once.

Simple illustration - and I apologize ahead of time - I know the formatting
won't look right, but I'm hoping you'll get the idea.

BEFORE

Joe West Div Sales Dept 1
Joe West Div Sales Dept 2
Joe West Div Sales Dept 3
Joe West Div Sales Dept 4
Fred East Marketing 132
Fred East Marketing 332
Fred East Marketing 423
Fred East Marketing 428

What I would like it to look like:

Joe West Div Sales Dept 1
2
3
4
Fred East Marketing 132
332
423
428

I've an idea I might be able to do this with a pivot, but I'm not sure and
don't know how.
I've an idea maybe I could do this with consolidate, but I'm not sure and
don't know how.


Any help would be greatly appreciated.

Thanks in advance!
Brad

Consolidating Redundant Text
 

Brad

In my opinion, Paul's suggestion of hiding with CF is the best way to go.

If you actually delete the redundant items you will run into problems when
you want to sort or filter on Name or Division.


Gord Dibben MS Excel MVP

On Wed, 6 Jan 2010 07:47:01 -0800, Brad Autry
wrote:

My issue:

I've a worksheet with 17 columns of data.
Total is roughly 10,000 rows.

Of those 10,000 rows, I am dealing with roughly 1000 different items.

That being the case, each item has roughly 10 rows, where the first 15 of 17
pieces of data are identical.

For strictly aesthetic purposes, I would like to have the redundant text
appear only once.

Simple illustration - and I apologize ahead of time - I know the formatting
won't look right, but I'm hoping you'll get the idea.

BEFORE

Joe West Div Sales Dept 1
Joe West Div Sales Dept 2
Joe West Div Sales Dept 3
Joe West Div Sales Dept 4
Fred East Marketing 132
Fred East Marketing 332
Fred East Marketing 423
Fred East Marketing 428

What I would like it to look like:

Joe West Div Sales Dept 1
2
3
4
Fred East Marketing 132
332
423
428

I've an idea I might be able to do this with a pivot, but I'm not sure and
don't know how.
I've an idea maybe I could do this with consolidate, but I'm not sure and
don't know how.


Any help would be greatly appreciated.

Thanks in advance!
Brad