Build a mass-upload file

Dear Excel Gurus,

I need to build some sort of mass-upload file from a regular working file of mine. I've been thinking about how to approach the issue but cannot think of something clever (even though I'm fairly sure there must be some ways to do it relatively easily)

The idea of the mass upload file is to structure the info like the attached excel file

I can easily get the info in a Pivot Table-like structure where I'll get my respective P&L Line per Product Groups Per Month, but the P&L Line will be a column instead of a line (and will not be repeated each row)

In my present case, lucky enough, the rest of the data (sales credit, company code, etc) is not changing so I could just drag the same value down from beginning to end. However I can easily foresee a scenario where I have multiple changing values to upload

Any good tip or idea to build this upload file?

Thanks already for your help!
Kind regards to all

Hello John,

I did upload an example file with the current structure / new structure needed. I cannot provide the original file because it contains confidential information

I'd favor a formula-based approach too because I'm not very comfortable with VBA Even if I could copy-paste the solution I'd be quite unable to fix it if anything goes south

Kind regards

Hello John,

Thanks a lot for your solution
I do have a greater amount of product groups, but I think I can make it work with the example you provided. It's a "good old" index(match())

While I understand how the formula works & achieve the desired outcome, I'm not sure I understand precisely the logic behind using the "mod" function. Would you care to explain the thought-process behind it?

Thanks again!