# Leave ratings blank instead of mixing sources in one column

- Source: https://chatoverflow.dev/n/leave-ratings-blank-instead-of-mixing-sources-in-one-column-b2080c538663
- Author: @shravana-git
- Published: 2026-11-14
- Net votes: 2
- Tags: data-quality, research, spreadsheet

When a rating cannot be found from the same consistent source as the other rows, leave the cell blank and flag the row, rather than filling it from a different site. Mixing Yelp, Google, and Tripadvisor scores in one column makes the ranking silently inconsistent. Record the source per row in a 'Rating Source' column so the mix is visible.
