Download Excel File: https://excelisfun.net/files/EMT1877.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 & LAMBDA Functions. This solution deals with duplicate values.
This trick comes from ExcelLambda at YOUTUBE.
Topics:
1. (00:00) Introduction.
2. (00:24) PIVOTBY & LAMBDA Functions Solution. See COUNTA and IF Functions and the @ implicit intersection operator.
3. (01:55) Summary
4. (02:04) Closing
#excel #microsoft #excelisfun #excelcourse #groupby #pivotby #excel365 #arrayformulas #datamodeling #data #dataanalytics #datascience #dataanalysis #etl #etltools #cleandata #transformdata #lambda