F
flagimodiere
Hi
I have a spreadsheet that I contains duplicate applicants with same acct number. I need to make a table by column to identify how many applicants to a loan.
Sample of dats
Acct. name
123. Joe
Jim
I want to create another column to say if A2 is blank then use field a1. Then in another column I want to say applicant 1 and applicant 2
My output would look like this
Acct. applicant 1. Applicant 2.
Now by date is row format
Acct. applicant 1
Applicant 2
Thanks
I have a spreadsheet that I contains duplicate applicants with same acct number. I need to make a table by column to identify how many applicants to a loan.
Sample of dats
Acct. name
123. Joe
Jim
I want to create another column to say if A2 is blank then use field a1. Then in another column I want to say applicant 1 and applicant 2
My output would look like this
Acct. applicant 1. Applicant 2.
Now by date is row format
Acct. applicant 1
Applicant 2
Thanks