Use row values as a new column and fill down to their corresponding values

[741yy1]

I'm relatively new to Power Query and trying to clean some data. Here's a sample dataset within Power Query.

I need to create a new column called "Standards" and assign values such as 1.1-Governance, 2.1-Consumers, 3.1-Flows, 4.1-Workplace based on their respective documents. Subsequently, I need to remove these values from the "Document NO" column.The desired result would be something like the image below.

[741yy1]

Thanks, Ahmedx. It works perfect. 

[Ahmedx · Accepted solution]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjBRN31Wo_xcZRODF?e=mVzYYv