Splitting records based on qty with calculation

[harishgg1]

hi

hope this helps !!

https://www.sqlshack.com/multiple-options-to-transposing-rows-into-columns/

Efficiently convert rows to columns in sql server