S
Sly929
Ok, I got another situation: I have data for the same client on multiple
lines, because each string of raw data contains different transaction
such as Beginning balance. Another string of raw data will contain
Withdrawl, and another string will contain gain/loss and so on. all the
strings pertain to one client. Some clients will have more strings of
raw data depending on the amount of transaction the client has.
So in my spreadsheet, on line A1 I got the beginning balance amount
from the 1st string of raw data, and on line A2 I got a withdrawl from
the 2nd string of raw data, and so on, no I created a second
spreadsheet, I want to combine all the transactions onto one line, but
the problem I am running into is the raw data changes all the time, one
client will have a beginning balance, withdrawl, but no gain/loss,
other might have different transactions such as beginning balance, no
withdrawl, but still have gain/loss, so the raw data will change. I
have ran dry of ideas.....
lines, because each string of raw data contains different transaction
such as Beginning balance. Another string of raw data will contain
Withdrawl, and another string will contain gain/loss and so on. all the
strings pertain to one client. Some clients will have more strings of
raw data depending on the amount of transaction the client has.
So in my spreadsheet, on line A1 I got the beginning balance amount
from the 1st string of raw data, and on line A2 I got a withdrawl from
the 2nd string of raw data, and so on, no I created a second
spreadsheet, I want to combine all the transactions onto one line, but
the problem I am running into is the raw data changes all the time, one
client will have a beginning balance, withdrawl, but no gain/loss,
other might have different transactions such as beginning balance, no
withdrawl, but still have gain/loss, so the raw data will change. I
have ran dry of ideas.....