Forum Discussion

sherylmeg's avatar
sherylmeg
Frequent Visitor
8 years ago
Solved

Import from Excel - Advanced Editor question

I'm trying to import an Excel spreadsheet but the data in the sheet has rows grouped by date. An example:   Item Ship Date 522  Jan-20, 2018 747   642   834   414  Jan-21, 2...
  • Sean's avatar
    8 years ago

    sherylmeg

    In the Query Editor - right-click on the ShipDate Column Header and select => Fill => Down