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