Microsoft Power Query Deep Dive: Split by new line character & Rename columns dynamically!

Learn how to use Microsoft Power Query to clean and organize your data, specifically by splitting data using a delimiter.
This project will walk you through step by step on how to split data by a new line character in order to better analyze and visualize your data. We will also look at how to dynamically rename our columns using a #table within power query.
Perfect for anyone looking to improve their data cleaning skills!
Credits to renaming columns solution:
wmfexcel.com/2...