Match/ Merge columns

G

Guest

I wrote a previous message, but I didn't know if it was clear. I am trying
to take data from the months of March and April and merge them together to
get one complete spreadsheet of each person's account for each month. Is
there a way to do this? I have been sorting by ID# and doing the rest
manually.

A B C D
1 ACCT BAL
2 NAME ID # MARCH
3 ASHLEY 111-11-1111 88
4 BRIAN 222-22-2222 32
5 CARL 333-33-3333 48
6 DAVID 444-44-4444 92
7 EVAN 555-55-5555 25
8 FRANK 666-66-6666 108
9
11 ACCT BAL
12 NAME ID # APRIL
ASHLEY 111-11-1111 100
BRAD 888-88-8888 28
CARL 333-33-3333 52
DAVID 444-44-4444 105
DERRICK 999-99-9999 74
EVAN 555-55-5555 35
PAUL 454-44-4545 86



COMPLETE END RESULT

ACCT BAL ACCT BAL
NAME ID # MARCH APRIL
ASHLEY 111-11-1111 88 100
BRAD 888-88-8888 0 28
BRIAN 222-22-2222 32 0
CARL 333-33-3333 48 52
DAVID 444-44-4444 92 105
DERRICK 999-99-9999 0 74
EVAN 555-55-5555 25 35
FRANK 666-66-6666 108 0
PAUL 454-44-4545 0 86
 
N

Nick Hodge

You data structure is not good, if you could get the date as the last
column (Field) against every record then a pivot table would work great,
with customers and accounts as a row field, the balance as a value field and
the date (month) as a column field.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top