Download Excel File: https://excelisfun.net/files/EMT1876.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the PIVOTBY & SINGLE Functions. This trick comes from viktorasgolubevas at YOUTUBE.
Topics:
1. (00:00) Introduction.
2. (00:25) PIVOTBY & SINGLE Functions Solution.
3. (01:48) Summary
4. (02:23) Closing

#excel #microsoft #excelisfun #excelcourse
#groupby #pivotby #single #singlemom #singlelife #excel365 #arrayformulas #datamodeling #data #dataanalytics #datascience #dataanalysis #etl #etltools #cleandata #transformdata