I have a column with multiple shop order numbers and another column with a quote number, but the quote number is currently only associated with one shop order number line. I want to pull the quote number down to all shop order lines when the first 9 digits are the same. So in the screenshot below, I'd like the quote # 82568 to be on every line that starts with 15336-008. How do I do this? I'm new to Power BI.