How do i duplicate rows

ephramz , merge on name, or order number and then expend

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Crossjoin or generate with filter in DAX

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

ephramz,

Use Merge Queries in Query Editor - https://docs.microsoft.com/en-us/power-query/merge-queries-overview

1. Select Merge Queries or Merge Queries As New (if you want the output as a new table)
2. Choose the tables and join column (use Ctrl + Click to select multiple columns)
3. Select Join Kind and click ok
4. Check the last column and click the Expand icon on the column's right top side
5. Choose the columns that you want

Best Regards,
Siva Mani
Proud to be a Super User!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.