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 and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.