I have the following scenario in my worksheet.
The thing here is that Row1,Row2 and Row3 come from one query and Row4, Row5,...Rown come from another query ,Also, the number of rows in the second query are based on a condition , so there is a possibility where in i can get no results based on the condition as well..
My question is, is there any possibility to shift the total3 row dynamically upwards or downwards based on the number of rows in query2 ?? Please let me know if there is any option in excel or any script for the same.
Thanks and Regards