G
George
Hi,
I upload a table that has many accounts names. I would like to separate out
all the accounts but my problem is that the account name is stated at the top
of all the client numbers in the same Field 1 and is not listed in the next
field, e.g
Field 1 Field 2
Account Name: Flexible accounts
Client account # 1 $122
Client account # 2 $2
Client account # 3 $199
Account Name: Floating accounts
Client account # 1 $46
Client account # 2 $36
Client account # 4 $1
Client account # 5 $77
Is there a way to separate the table such that each account name has the
client account #s in it.
As the client numbers can appear in more than 1 account this kinda makes it
hard.
Many thanks
George
I upload a table that has many accounts names. I would like to separate out
all the accounts but my problem is that the account name is stated at the top
of all the client numbers in the same Field 1 and is not listed in the next
field, e.g
Field 1 Field 2
Account Name: Flexible accounts
Client account # 1 $122
Client account # 2 $2
Client account # 3 $199
Account Name: Floating accounts
Client account # 1 $46
Client account # 2 $36
Client account # 4 $1
Client account # 5 $77
Is there a way to separate the table such that each account name has the
client account #s in it.
As the client numbers can appear in more than 1 account this kinda makes it
hard.
Many thanks
George