Cut & paste & transpose

[Queenie Balb]

Hi,
I am creating a budget file where the periods are in a row.
When creating the Upload File, I need to transpose all those rows into columns.
I also have to transpose: the GL code, the product codes and the Periods themselves.
How can I make this smarter and faster without having to go thru a lot of cut&paste&transpose?
Please see the file attached.
Thanks

[JBeaucaire]

This will do it based on the exact layout presented.

1) Sheet names are the same
2) Budget layout must be as show, data starting in row3 with cost center in C1
3) In Upload File sheet only puts values in the PRODUCT CODE column if the value is text, numerics(percentages) are skipped as shown in your example

Please Login or Register  to view this content.