Spreadsheet: 220299d1363114719-condense-duplicate-data-to-one-row-data-in-same-column-in-new-row-golf-stats
Sheet: Sheet4

 | You can change "Count of Hyundai" to (almost) whatever you want.  If you want to just keep the name, leave a space at he end
 | Values
Row Labels | Hyundai | Sony | Count of Humana | Count of Farmers
[NAME] |  |  |  | 1
[NAME] |  |  | 1 | 1
Alker Steven |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1
[NAME]
Appleby Stuart |  |  | 1 | 1
[NAME]
[NAME]
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  |  |  | 1
[NAME]
Barnes Ricky |  | 1 | 1 | 1
[NAME]
Beljan Charlie | 1 |  | 1 | 1
[NAME] |  | 1
Bettencourt [NAME]
[NAME]
Blanks [NAME]
Blixt [NAME] | 1 | 1 |  | 1
Block [NAME]
[NAME] |  | 1 | 1
[NAME] |  | 1 | 1 | 1
Bowditch Steven |  | 1 | 1 | 1
Bradley Keegan | 1 | 1 |  | 1
Bradley [NAME] |  | 1 | 1 | 1
[NAME] |  |  | 1
[NAME]
Bryant Bart |  | 1 | 1
[NAME] |  |  |  | 1
Cabrera-Bello Rafael
[NAME] |  | 1 | 1
Cantlay [NAME] |  |  | 1 | 1
[NAME] |  | 1
[NAME]
[NAME] Roberto |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME]
[NAME] |  |  | 1 | 1
Chappell Kevin |  |  | 1 | 1
[NAME] |  | 1 |  | 1
Christian [NAME]
Cink [NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1
Claxton Will |  | 1 | 1 | 1
[NAME] |  | 1
[NAME]
[NAME] |  |  |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 |  | 1
[NAME]
[NAME] |  |  | 1 | 1
Curtis [NAME] | 1 | 1 |  | 1
[NAME] |  | 1 |  | 1
[NAME] |  | 1 | 1
[NAME] |  |  |  | 1
de Jonge Brendon |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME]
[NAME]
[NAME]
Driscoll [NAME] |  |  | 1 | 1
[NAME] | 1
[NAME] |  | 1 | 1
Durant [NAME]
[NAME]
Els Ernie
[NAME] |  | 1 | 1 | 1
Ernst Derek |  | 1 | 1 | 1
[NAME] |  |  | 1
Every [NAME] |  | 1 | 1 | 1
Fdez-Castano Gonzalo
Fiedler Jon |  |  |  | 1
[NAME] |  |  | 1 | 1
[NAME]
Flores [NAME] |  | 1 | 1 | 1
Fowler [NAME] | 1 |  |  | 1
[NAME] |  |  |  | 1
Fraser Marcus
Fritsch Brad |  | 1 | 1 | 1
[NAME]
Funk Fred |  | 1
[NAME]
[NAME] | 1 | 1 | 1 | 1
[NAME]
[NAME]
[NAME] |  | 1 | 1 | 1
Garrigus [NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
Goosen Retief
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME]
[NAME]
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME] | 1 |  | 1 | 1
[NAME] |  |  |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME]
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME]
Harrington Scott
[NAME] |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1
[NAME] | 1 | 1 |  | 1
[NAME] |  | 1 |  | 1
[NAME] |  | 1 |  | 1
Hicks Justin |  | 1 | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  |  |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
Huh John | 1 | 1 |  | 1
Hurley John
Ikeda Yuta |  | 1
Imada Ryuji |  | 1
[NAME] |  |  | 1 | 1
Ishikawa Ryo |  |  | 1 | 1
[NAME]
[NAME]
[NAME]
[NAME] |  |  | 1
[NAME] |  |  |  | 1
[NAME] | 1 | 1 |  | 1
[NAME] | 1 | 1 | 1
Jones [NAME] |  | 1 | 1 | 1
Jones Steve |  |  | 1
[NAME] |  |  | 1 | 1
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
Kraft Kelly
[NAME] | 1 | 1 | 1
[NAME] |  |  |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  |  |  | 1
Langley Scott |  | 1 | 1 | 1
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] | 1 | 1 |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
Lingmerth David |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME]
Love [NAME] |  | 1 | 1
[NAME]
Lowry Shane
Lunde Bill
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1
[NAME] | 1 |  |  | 1
[NAME] |  | 1 | 1 | 1
Manassero Matteo
[NAME] |  | 1 | 1 | 1
Mathis David |  | 1 | 1 | 1
[NAME] |  | 1
[NAME] |  |  | 1 | 1
Mayfair Billy |  |  |  | 1
McCabe Michael |  |  |  | 1
[NAME] |  |  | 1
McDowell Graeme
[NAME] |  |  | 1
[NAME]
[NAME] | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  |  | 1 | 1
Molinari Francesco
[NAME] | 1 | 1
Na [NAME] |  | 1 | 1
[NAME] |  |  | 1 | 1
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME]
[NAME]
[NAME] |  | 1 | 1
Ogilvy Geoff |  |  | 1 | 1
O'Hair Sean |  |  | 1 | 1
O'Hern Nick
[NAME]
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1
[NAME] |  |  |  | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  |  | 1
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
Persons [NAME] |  | 1
[NAME]
Pettersson Carl | 1 | 1 | 1
[NAME] | 1 | 1 |  | 1
Points D.A. |  |  | 1 | 1
[NAME] | 1 | 1
Poulter [NAME] | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1
[NAME] |  |  | 1
[NAME]
[NAME] |  | 1 |  | 1
[NAME] |  | 1 | 1 | 1
Ridings Tag |  | 1 | 1 | 1
[NAME]
[NAME]
Rollins John |  | 1 | 1 | 1
[NAME] |  |  |  | 1
[NAME]
[NAME] |  | 1 | 1
[NAME]
[NAME]
Schwartzel Charl
[NAME]
Senden John |  | 1 | 1 | 1
[NAME]
Short Jr. Wes |  | 1 | 1
Siem Marcel
[NAME] | 1 | 1 | 1
[NAME] |  | 1 |  | 1
Slocum Heath
[NAME] | 1 |  | 1 | 1
[NAME] |  |  | 1
[NAME] |  |  |  | 1
[NAME] |  | 1 | 1
[NAME] | 1 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1
[NAME] |  |  | 1
[NAME] |  |  | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME]
[NAME]
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
Streelman [NAME] |  | 1 | 1
[NAME] | 1
[NAME] |  | 1 | 1
[NAME] |  | 1 | 1 | 1
Summerhays Daniel |  | 1 | 1 | 1
Sutherland [NAME]
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1
[NAME]
Teater [NAME] |  | 1 | 1 | 1
[NAME] |  | 1 |  | 1
[NAME] |  | 1 | 1 | 1
[NAME]
Tomasulo [NAME] |  | 1 |  | 1
[NAME] |  |  | 1
Trahan D.J. |  |  | 1
Tringale Cameron |  | 1 | 1 | 1
[NAME] |  |  | 1 | 1
Vegas Jhonattan |  |  | 1 | 1
Verplank Scott |  |  | 1
[NAME] |  |  | 1 | 1
[NAME] | 1 | 1 | 1
Walker Jimmy |  | 1 | 1 | 1
Watkins [NAME] |  | 1 | 1 | 1
[NAME] | 1 |  |  | 1
[NAME] | 1
[NAME] |  | 1 | 1 | 1
Weir Mike |  | 1 | 1 | 1
Westwood [NAME]
Wi [NAME] |  | 1 | 1 | 1
[NAME] |  | 1 | 1 | 1
[NAME] |  | 1
[NAME] | 1 | 1 | 1
Wittenberg [NAME] |  | 1 | 1 | 1
Woo [NAME]
Wood [NAME]
Wooding Jeremiah
Woodland Gary |  |  | 1 | 1
Woods Tiger |  |  |  | 1
[NAME] |  | 1 |  | 1
Grand Total | 30 | 144 | 156 | 156