Transpose Batch Excel Data

Hello, I have a spreadsheet with rates per lb that I need to transpose into a different format so I can upload into a rating system. I have attached an excel spreadsheet with the original data on the first tab and the desired result on the second tab. I am trying to figure out an easy way to this as the main file has about 1000 rows that need to be transposed. Hope someone can help.