I have downloaded sales data from webstore and the rows are itemised, but they only provide the date in one cell for the order.

I am trying to work out how I can auto fill the blank cells with the missing dates automatically?

I will then have the same data on another sheet so it would need to carry over for when the dates are filtered.

enter image description here

  • What should the values be? We can't invent the missing dates. – Tomas Zubiri May 14 at 18:43
  • @Tomas I take it that the omissions are just repetitions of the above values like you would find in a pivot table. – Wolfgang Jacques May 14 at 19:28
  • Yes exactly they are to be repeated. Each row used represents a sold product item within the customer order but it only shows the date once. The issue I have is that order sizes (number of items) varies, so rather than define a specific cell, I need to try some thing like if the cell below is empty, enter the value from the above cell. Sorry i am still a novice so my explanations might not be the best. – ShadowFingers May 15 at 19:08

You can use something like =IF(A4="";B3;A4) to take the above date if the left cell is empty. You will possibly have to use an auxiliary column for that.


  • Thanks Wolfgang. I will give this a try. Thank you so much, I really appreciate you taking the time to help. – ShadowFingers May 15 at 19:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.