|
|
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? |
. |
|
|
8x10 Print Fleetwood Mac Peter Green Mick Fleetwood John McVie 1969 MEF
$14.99
Fleetwood Mac Tour John McVie Bass Guitar Pick
$25.00
FLEETWOOD MAC Nicks vtg Magnet BUTTON & PIX + free Rare CD 1980 Japan TUSK Sdbd
$39.00
RARE "Fleetwood Mac" John McVie Hand Signed B&W Promotional Photo COA
$149.99
FLEETWOOD MAC Nicks vtg BUTTON / PIN & PIX + free Rare CD 1979 Boston TUSK.
$38.99