I am not sure if I have fully understood the question. Do you want to load this data from Excel to QlikView or do you want to create similar data? You can do transformation within QV to clean the data. There are many functions and you can use Peek() & Previous() record based functions to clean up your data. Please can you explain in detail or post an example for more understanding.