Separating multiple entries in one line in separate table columns

[dastr]

Hi all,

I have the following table:

Table A
Person - Symbol
Inna - beta, theta, delta
Anna - beta, theta
Maria - beta, theta, delta, gamma, theta2


Does anyone know how I can get the entries from the Symbol line in separate columns?
Thanks.

 

[vbaInet]

You seem to be dodging your biggest problem... Normalisation. You've already been advised to normalise your tables -->

http://www.access-programmers.co.uk/forums/showthread.php?p=1169633#post1169633

 

[dastr]

Hi VBAInet,

Correct, however I have way too many entries and I cannot figure out how to normalize my data; thats why I am kinda thinking of a way around.

If you think of anythin, pls let me know. Thx

You seem to be dodging your biggest problem... Normalisation. You've already been advised to normalise your tables -->

http://www.access-programmers.co.uk/forums/showthread.php?p=1169633#post1169633

 

[vbaInet]

You can ask the guys on your original thread. I'm sure they will be willing to help. If there's anything I feel will be beneficial to you, will mention it in that thread.

 

[Bryan]

Are you trying to parse the data in a field so that you can split it into several pieces? (sorry, but I have no idea what you mean by lines and columns.)

If that is the case, take that data out to Excel and use it to parse the column.