Reshaping Datasets with Python in Excel

Tony Phillips, an experienced Microsoft Office user and writer for How-to Geek, shares his expertise in reshaping datasets in Excel.

Phillips explains that he's particular about dataset structure because it makes his life easier down the line. He's used to working with wide data, but prefers long data where each column represents a field and each row represents a record.

To transform his 'wide' weather dataset into 'long' format, Phillips uses Python code directly in Excel. The process is called unpivoting, which can also be achieved through Power Query's Unpivot Columns command.