Media Summary: Examine a case study where data is combined using 3 different delimiters for 3 different reasons. The major issue is 1. Replace all spaces with " " symbols, 2. Replace " " with " " until there is only one pipe symbol left, 3. This video shows how you can create a condition
Power Query Split Text Into - Detailed Analysis & Overview
Examine a case study where data is combined using 3 different delimiters for 3 different reasons. The major issue is 1. Replace all spaces with " " symbols, 2. Replace " " with " " until there is only one pipe symbol left, 3. This video shows how you can create a condition