Issue getting data organized

[laughingman1906]

Hi Im having an issues with a .csv file that is just really junked up and disorganized. I managed to filter it mostly so that I know which values were SUPPOSED to go to which fields however, Im having trouble getting it exported to access and getting it normalized.

I'm trying to build a basic contacts list and I've got an

SID that relates to each

First name
Last name
phone number
email.

However the records were messed up so the best I could do was filter it so that I knew which SID each property field ( first name, last name, phone number, it is associated with ) Can anyone provide some insight on what I can do so that I can simply pull up one SID and have the associated properties that should be associated with it pop up or be joined.

(p.s. I know what I should have done from the beginning was make a single entity

UID
first name


last name
phone number
email

but Im trying to recreate a DB that can read the raw generated data that I do have ( something in the range of a couple hundred thousand records ). any help would be GREATLY appreciated I'm completely stumped as to even what Im looking for.

[alansidman]

I don't understand your issue. Please re-explain and use an example to help demonstrate what the problem is and what you want for results.