I imported the file that is in .txt, with the following code
Code:
import delimited file.txt, delimiter(",", collapse) clear
Data in .txt file is as following.
Code:
    
 ,week:,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74
35,userA,36,45,46,46,46,46,49,49,49,49,49,49,47,47,49,50,58,59,59,59,60,61,61,61,61,61,61,61,61,61,62,62,62,62,62,62,62,59,59,59,59,57,56,56,56,,,,,,61,62,60,60,61,61,61,61,57,56,56,56,56,60,58,58,58,58,58 203,userB,-4,-5,-5,-5,-5,-5,-7,-7,-7,-7,-7,-7,-7,-8,-8,-9,-2,-2,-2,-5,-4,-4,-4,-4,-4,-4,-4,-4,-3,-3,-2,-2,-6,-7,-7,-7,-7,,,,,-4,-4,-4,-5,-5,-5,-5,-5,-5,,,,,,,,,-5,-5,-5,-5,-5,-5,-5,-5,-5,,
The problem is weeks with missing values are automatically moved to the latest weeks, not in the middle weeks like it should be. How to fix it? Thank you for your help in advanced!

P/S:
I can solve it by replacing ,, to ,., to represent missing values. But I would like to know if there is method to solve it directly. Because I import data directly from a website.