Advanced data transposing

First day at my first job, I have been assigned the work to transpose excel data, my senior gave me instructions to do them by hand ... but that would be an absolute pain in the ***. I bet there are smarter solutions out there. Upon some investigation I realize that this job can be made a lot easier by a bit of VBA, but unfortunately I'm not VBA literate. Any help would be greatly appreciated!

my data looks like this:
type 1 type 2 type 3
Company A | Jewel A |2% |8% |10%
Jewel B |4% |0% |0%
Company B | Jewel A |2% |8% |10%
Jewel C |4% |0% |0%

(the different types are discounts)

and I need it to look like this:
Jewel A Jewel B Jewel C
type 1 type 2 type 3 | type 1 type 2 type 3 | type 1 type 2 type 3
Company A | 2% |8% |10% |4% |0% |0%
Company B | 2% |8% |10% |4% |0% |0%

I've also included a sample of the data that I need to transpose, from the BnW file to the Color file. It's a little messy that might take a little time to decipher, but I sincerely appreciate any help available. Even if you just tell me that "your data is not salvageable you're doomed to do it manually" would be helpful.

Thanks for your reply.

I did some cleaning up with the data and now every company has equal number of categories.

So now the transposing is to be done with these rules, from "CleanedRawData" to "Color":
1. purple figures --> on credit note, green figures --> on invoice
2. combined --> under each category

Any insight?

Thanks a lot! Really appreciate your help.