|
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
Does anyone know how to make a pivot table in Excel?
I have several thousands of rows on a spreadsheet. But, I want to condense them in such a way that it eliminates duplicate rows.
Here is an example of what I have: Patient Name Chart # Treatment Date Insurance Smith, John 12345 1/21/08 Blue Cross Smith, John 12345 1/21/08 Blue Cross Smith, John 12345 1/21/08 Blue Cross Smith, John 12345 5/09/08 Medicare What I'd like to do is get rid of any dupes and get this result: Patient Name Chart # Treatment Date Insurance Smith, John 12345 1/21/08 Blue Cross Smith, John 12345 5/09/08 Medicare Unless someone knows a formula, I thought that maybe a pivot table would work, except I have no idea how and the 'Help' isn't very helpful. Any idears? |
. |
|
|
FLEETWOOD MAC Lp Rumours 1977 Orig Warner Bros BSK 3010 w/Poster~Plays super EX
$34.49
Vintage Fleetwood Mac Artist Signed Poster Framed
$49.99
Fleetwood Mac. Fleetwood Mac, 1976 Reprise Stereo, MS-2225
$22.95
Fleetwood Mac - Tango In The Night LP Forest Green Vinyl Exclusive Limited Ed.
$67.50
Fleetwood Mac: Greatest Hits - Audio CD By FLEETWOOD MAC - VERY GOOD
$5.37