Column showing blank instead of its data

[Kayfynn]

I'm trying to import data from a sharepoint list, however when the data is imported 1 columns which is supposed to contain names shows as blank whiles the other columns populates their respective data. 

Would anyone know why this is happening and what i can do to fix it?

[VishalJhaveri · Accepted solution]

Hi @Kayfynn 

Please look at the attached image to obtain your requirement.

Thank you.

[Kayfynn]

Thank you very much. am good now

[rajulshah]

@Kayfynn ,

Can you please give more information on this?
Like the datatype of the column?

[Kayfynn]

@rajulshah The data type for the column is person and now loads with IDnumbers. how can i get the actual names of the individuals since i need that to connect another table

[Kayfynn]

@rajulshah The data type for the column is person and now loads with IDnumbers. how can i get the actual names of the individuals since i need that to connect another table