How to Clean survey data separated by delimiter into one column for analysis
#DataAnalysis #Excel #GoogleSheets #CleanSurveyData #DataInOneColumn
In this video you will learn how to clean survey data separated by comma delimiter into one column for further analysis using the SPLIT() function to split data in one cell separated by comma , then use FLATTEN() function to stack all the different data in cells into one column after which you'll use SORT & UNIQUE function to sort ascending and eliminate duplicate values
⌚ Timestamps
0:00 Introduction
1:41 How to split data separated by delimiter, comma
3:51 Name range in google sheets
5:05 Stack all split data in one column using Flatten function
6:22 Sort data in one column in ascending order SORT() function
7:31 Eliminate duplicate using UNIQUE() function
8:20 COUNTIF() to count individual items split
🚩 Connect with me on social
1️⃣ LinkedIn:www.linkedin.com/in/christophersabiti/
2️⃣ Twitter: / sabiti14
3️⃣ Facebook: / sabiti.christopher
4️⃣ TikTok: tiktok.com/@sabtechonline
🔔 Subscribe to my YouTube channel
https://www.youtube.com/c/sabtechonli...
🎬 Want to watch again? Navigate back to my YouTube channel quickly
/ @sabtechonline
#Excel #Dashboard #Excel_dashboard #free_templates #excel_template #free_Excel_Template #Interactive #Dynamic #professional #Infographics # KPIs #SLA #Service_Level_Management #HR #PowerpointSlides #createpresentations #GraphicDesign #BuisnessPurpose #PowerPoint #RealEstate #Villa #PropertyManagement #Property #other_level's #other_levels #otherlevel's #PowerPoint #Tutorial #how_to_create #dashboard #Dashboards #excel_dashboard #PowerPoint_dashboard #excel_report #School #PowerPoint_presentation #PowerPoint_templates #Presentations #Freetemplates #free_Templates #Video_Tutorial #KPI #SLA #Service_level_Managment #Excel_Dashboard #Chart #data_analyst #PowerBI #GoogleDataStudio #GoogleSheets
#HowToCleanSurveyDataSeparatedByDelimiterIntoOneColumnForAnalysis