Multiple IF statemen assistance

[pbourque]

What IF statement could be used in the following example to receive the correct company (currently displayed as a header in multiply columns) in Row1, if the location row has a value in that column:
Below is the original file:

	Original output
Ledger Account	Location	SBC	Cities Company	Vet Company	AR Company	SD Company	ID Company
Tax	Paw	0.00	0.00	0.00	0.00	0.00	550.00
Tax	choice	0.00	0.00	0.00	0.00	0.00	375.00
Tax	LA	0.00	0.00	0.00	0.00	(11,363.54)	0.00
Tax	Pass	(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	SB	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	Dogs	0.00	0.00	0.00	0.00	(227.52)	0.00
Tax	Reference	0.00	0.00	0.00	0.00	0.00	0.00

Would add Column B to hold the IF Statement:

Would like it to transpose to this:
Location	Company	tax
Paw	ID Company	550.00
choice	ID Company	375.00
LA	SD Company	(11,363.54)
Pass	SBC	(2,330.74)
SFV	SD Company	(3,592.52)
SB	SD Company	(5,547.42)
after	AR Company	(131.14)
Dogs	SD Company	(227.52)
Reference	Vet company	4,500.00

 

[awoohaw]

You can try this. But the Reference Line get an error. Due to that there is no 4,500 value in the Vet Company column.

Book1
	A	B	C	D	E	F	G	H
1	Ledger Account	Location	SBC	Cities Company	Vet Company	AR Company	SD Company	ID Company
2	Tax	Paw	0	0	0	0	0	550
3	Tax	choice	0	0	0	0	0	375
4	Tax	LA	0	0	0	0	-11,363.54	0
5	Tax	Pass	-2,330.74	0	0	0	0	0
6	Tax	SFV	0	0	0	0	-3,592.52	0
7	Tax	SB	0	0	0	0	-5,547.42	0
8	Tax	after	0	0	0	-131.14	0	0
9	Tax	Dogs	0	0	0	0	-227.52	0
10	Tax	Reference	0	0	0	0	0	0
11
12
13			Company	Tax
14		Paw	ID Company	550
15		choice	550	375
16		LA	0	-11363.54
17		Pass	0	-2330.74
18		SFV	0	-3592.52
19		SB	-3592.52	-5547.42
20		after	0	-131.14
21		Dogs	0	-227.52
22		Reference	#CALC!	#CALC!
Sheet1

Cell Formulas
Range	Formula
C14:C22	C14	=FILTER(C1:H1,(C2:H2<>0)*(SEQUENCE(1,6,1,1)))
D14:D22	D14	=FILTER(C2:H2,(C2:H2<>0)*(SEQUENCE(1,6,1,1)))

 

[Fluff]

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

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.