Trying to transpose Company Colum headings (company)into new single column next to appropriate location (correct location has the value)

[pbourque]

sample are below:
Any assistance is appreciated.

	Original output
Ledger Account	Location	Access	Cities Company	Vet Company	AR Company	CA Company	ID Company
Tax	Paw	0.00	0.00	0.00	0.00	0.00	0.00
Tax	choice	0.00	0.00	0.00	0.00	0.00	0.00
Tax	LA	0.00	0.00	0.00	0.00	(11,363.54)	0.00
Tax	Pasadena	(2,330.74)	0.00	0.00	0.00	0.00	0.00
Tax	SFV	0.00	0.00	0.00	0.00	(3,592.52)	0.00
Tax	South Bay	0.00	0.00	0.00	0.00	(5,547.42)	0.00
Tax	after	0.00	0.00	0.00	(131.14)	0.00	0.00
Tax	Pets	0.00	0.00	0.00	0.00	(227.52)	0.00
Tax	Refferal	0.00	0.00	0.00	0.00	0.00	0.00

Would like it to transpose to this:
Location	Company	tax	tax	tax	tax	tax	tax
Paw	ID Company	0.00	0.00	0.00	0.00	0.00	550.00
choice	ID Company	0.00	0.00	0.00	0.00	0.00	375.00
LA	CA Company	0.00	0.00	0.00	0.00	(11,363.54)	0.00
Pasadena	Access	(2,330.74)	0.00	0.00	0.00	0.00	0.00
SFV	CA Company	0.00	0.00	0.00	0.00	(3,592.52)	0.00
South Bay	CA Company	0.00	0.00	0.00	0.00	(5,547.42)	0.00
after	AR Company	0.00	0.00	0.00	(131.14)	0.00	0.00
Pets	CA Company	0.00	0.00	0.00	0.00	(227.52)	0.00
Refferal	Vet company	0.00	0.00	4,500.00	0.00	0.00	0.00

 

[Special-K99]

I haven't the time to solve this but...

The last column "tax" for Locations "Paw" and "Choice" and Refferal line
Where do you get 550 and 375 and 4500 from?
Those values dont appear in your original output