I have to replicate a Google Sheet, and am using ImportRange and Query together. I need Query also because the first sheet has urls under them, which I cannot have on the copied sheet. I was able to remove the urls by using Query Options no_format. Options no_value also does the same job. However, neither of them allow any format change to transfer, at least not that I have found. I want to have the bold format to transfer, font size to transfer, and new rows added in the middle of the sheet to transfer, but not color. Is there ability to do this in Query Options no_format or Options no_values? Or is there some other way I can make this happen?