The table has EXPIRY date column, and it does not repeat on all rows: This is a Option price table for MSFT(Microsoft), the data table is sorted by Expiry date on sheet 'BACKEND'.So, when I fetch via Query function, I only get one row value for Expiry column.
How can I get column FC on all related rows to repeat the Date Label for each row?
Google sheet link: https://docs.google.com/spreadsheets/d/1fzNH3pAGSeazbO1sh2CeopDJqJFfxqvPyeoCnk7l0X8/edit?usp=sharing
