Learn 3 different methods for creating unique IDs in your dataset when no unique ID exists. You can apply these methods to Excel or Google Sheets. Having a unique ID in your table of data makes it easier to reference specific rows of data when you are building out your summary reports and dashboards.
* Intro - 0:00
* Method 1: Sequential list of numbers - 2:32
* Method 2: Create random numbers as ID - 5:17
* Method 3: Concatenate columns together - 10:45
👉 Copy the Google Sheet: [ Ссылка ]
👉 Original blog post for this podcast episode: [ Ссылка ]
👉 Subscribe to Dear Analyst: [ Ссылка ]
👉 Excel for the Real World online class: [ Ссылка ]
Ещё видео!