M
maprime12
Hello all,
I've been banging my head against a wall trying to figure this out,
hopefully someone can help me. I have a spreadsheet that was generated
by a database program, unfortunately, it did not assign each value to
its own unique column. Instead, it took some of the data and inserted
them into the same column, albeit, onto different rows. To make
matters worse, there isn't even a pattern between rows (i.e. data that
can be moved to it's own column is evenly spaced). Here's a small
example of what I'm trying to do:
The first value BLOOM is a last name value, that stays in Column A, the
value Other and self and spouse are supposed to go into column B, the
value AET11, OXF1, BCBS are abbreviations for insurance companies, they
are supposed to go to column C. To make matters worse, some patients
don't have an insurance, as exampled by the the Bloom Self in the
example below. I have about 45667 rows to parse through.
BLOOM
Other
AET11
BLOOM
Self
OXF1
BLOOM
Self
HLHNET
bloom
Self
BLOOM
Self
OXF1
BLOOMBERG
Spouse
UN
BLOUNT
Spouse
UNITED
BLUM
Self
BCBS
BLUM
Self
BCBS
BLUM
Self
So, since there is no discernable pattern between rows, I am going to
assume that the only way to get Excel to move a cell over would be
telling it to parse column, looking for value of x, where x equals a
keyword, such as Self or Spouse. If it comes across a cell matching my
criteria, move it over one column to the right. If anyone can help me
come up with something, I would be most appreciative.
Regards,
Marvin
I've been banging my head against a wall trying to figure this out,
hopefully someone can help me. I have a spreadsheet that was generated
by a database program, unfortunately, it did not assign each value to
its own unique column. Instead, it took some of the data and inserted
them into the same column, albeit, onto different rows. To make
matters worse, there isn't even a pattern between rows (i.e. data that
can be moved to it's own column is evenly spaced). Here's a small
example of what I'm trying to do:
The first value BLOOM is a last name value, that stays in Column A, the
value Other and self and spouse are supposed to go into column B, the
value AET11, OXF1, BCBS are abbreviations for insurance companies, they
are supposed to go to column C. To make matters worse, some patients
don't have an insurance, as exampled by the the Bloom Self in the
example below. I have about 45667 rows to parse through.
BLOOM
Other
AET11
BLOOM
Self
OXF1
BLOOM
Self
HLHNET
bloom
Self
BLOOM
Self
OXF1
BLOOMBERG
Spouse
UN
BLOUNT
Spouse
UNITED
BLUM
Self
BCBS
BLUM
Self
BCBS
BLUM
Self
So, since there is no discernable pattern between rows, I am going to
assume that the only way to get Excel to move a cell over would be
telling it to parse column, looking for value of x, where x equals a
keyword, such as Self or Spouse. If it comes across a cell matching my
criteria, move it over one column to the right. If anyone can help me
come up with something, I would be most appreciative.
Regards,
Marvin