I looked at your docx and see "Additonal Variable 1". What the heck does that even mean? If someone tells me there is to be an "additional" variable, I would expect to have a variable name and a description of where the values would come from. You have a list of values in that column.   If these different rows (you provide a very limited picture so hard to tell) actually all belong in the same record then perhaps if the data is provided as a text file you can read it the three row values into separate variables that would allow mixing text, date values and other numeric values. Maybe. Or maybe your file needs to be restructured. Without a moderately complete example of the file contents it is very hard to tell if that is desirable or possible.   You are learning why spreadsheets are quite often not good ways to interchange data. That may be the main "learning" point at this time. Spreadsheets do not enforce any "variable" or "column" properties that a proper data structure does. ... View more