Transpose Data from rows to column in one tab to another

[Cameron419]

Hello, I'm working on populating data from rows in one tab to columns with a fill down of the ID and prices in another tab.

I attached the workbook. The data from the MP Tab is in rows starting at P3 and I need it transposed to the OF Template MP tab for the 1st ID 500805299 in the new tab in column E for all 8 rows and then put the prices in the corresponding rows 1-8 in Column I. Then repeat for the next ID in the MP Tab under the previous ID completed. I hope this makes sense as I have tried to do this with an offset but failed to make it work. Any help is greatly appreciated

Thanks

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[Cameron419]

I didn't attach the workbook. Sorry for the confusion on my post