Power Query - Split Text into Rows (the 3 Delimiter Problem)

Examine a case study where data is combined using 3 different delimiters for 3 different reasons. The major issue is splitting data stored on a single row into separate rows.

File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_PQ_SplitRows.zip

01:25 Bring data into Power Query
02:03 Examining how records are stored
02:26 Merging the column headings
03:50 Dealing with the side effects of the merge
04:49 Splitting the combined records into separate rows
05:21 Splitting the individual records into separate fields
05:46 Rename query and send the results to Excel
05:57 Video Recap