Table with a header 'EXP' column date values`

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



Your Answer

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

Browse other questions tagged or ask your own question.