View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EJR EJR is offline
external usenet poster
 
Posts: 3
Default Convert Columns to Rows based upon a duplicate value

I have columnar data in the four headings below;

A B C
D
Loan Number / Taxpayer ID Number / Customer Name / SCR21

It is possible that there is information for two customer four each loan.
Is there a way for my to compare the values in the "Loan Number" column in
rows 3 and 2, and if it matches the cell above, copy the contents for columns
B, C & D and paste the to Columns E, F & G in row # 2?

Thanks for any help, EJR