Assuming the data from the report you get is in A1:D10 with headers in Row1.

In G1:J1 you have the below headers. Note that the header text is exactly
similar to the one in the data example 'Tot' and not 'total'
Cust Tot Fax PH
Macys xx xx xx

Use the below formula in G2 and copy that to H2 and J2 ...and once done copy
the formula down for all 3 cells..

=SUMPRODUCT(--($A$2:$A$10=$G2),--($C$2:$C$10=H$1),--($D$2:$D$10))

If this post helps click Yes
---------------
Jacob Skaria


"Wanna Learn" wrote:

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