Hello
A report is send to me has 27 columns and at least 900 lines I need 3
columns
column a name of customer
column c has type of transaction
column d has number of transactions
Example
Macys Fax 10
Target PH 15
Macys ph 25
Macys Tot 35
Target Fax 5
Target Tot 20
K mart Fax 20
K mart PH 15
K mart Tot 35

My report is
column C I have name of customer
Column E I have Total
Column F I have Fax
Column G I have PH

Using the example above my report should look like this the example above
should be
Customer Total fax PH
Macys 35 10 25

I tried
vlookup and MATCH and does not work
Thanks in advance