|
|
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? |
. |
|
|
BILLY BURNETTE – BELIEVE WHAT YOU SAY 7" VINYL 45 RPM PROMO POLYDOR PD 14549 VG+
$7.99
Billy Burnette - Billy Burnette [New CD] Rmst, Reissue
$15.38
Billy Burnette - S/T - 1980 Columbia Records White Label Promo LP EX/VG++
$4.99
Signed Tangled Up In Texas by Billy Burnette (CD, Capricorn/Warner Bros.,1992)
$35.00
Billy Burnette - Coming Home (CD, Album) (Very Good Plus (VG+)) - 2935365877
$5.00