How to transform data into certain format

[D_Y]

Hi community,

I've been having some trouble converting the below format using the Transpose tool. 

I have data that currently looks like this, with the first row being the headers:

Organization	Teams	North America				Asia
		Total	Male	Female	Unknown	Total	Male	Female	Unknown
Organization 1	Red Team Total	9	5	3	1	9	1	6	2
Organization 1	Red Team 1	5	2	3	0	4	1	1	2
Organization 1	Red Team 2	4	3	0	1	5	0	5	0
Organization 2	Blue Team Total	1	1	0	0	8	2	6	0
Organization 1	Blue Team 1	1	1	0	0	8	2	6	0

I am trying to get it into the following format to help with dashboarding (if there is a better format than this, let me know):

Organization	Teams	Location	Gender	Value
Organization 1	Red Team Total	North America	Male	5
Organization 2	Blue Team 1	Asia	Female	6

Kindly asking for help as I tried using the Transpose tool but unsure of the exact steps to perform this transformation.

Thanks in advance!

[PhilipL]

@D_Y 

Not sure if this is dynamic enough for you, but check out a few of the reformatting methods used, they may help.