How to split colum value (with comma) to multiple columns

Hello Good Morning,



Could you please tell me how to split this , I am new Access DB, I worked in Sql Server but access new to me please help me here



I have the below data

Appid Names

100 John,Bob,Kondya, Lima

200 Shor,James,Kim

300 Cinem



I want to convert to



Appid Names Name1 Name2 Name3 Name4

100 John Bob Kondya Lima NULL

200 Shor James Kim NULL NULL

300 Cinem NULL NULL NULL Null



Thank you in Advance

Asita

How to split colum value (with comma) to multiple columns