Having only rows which are respectively filled

[soleimani1967]

Please look at below spreadsheet. I have 9 rows from 1 to 9. There are some empty cells between the numbers. I want to return only rows which are respectively filled in front of their rows where the result is generated between columns F to I (just like below spreadsheet). In fact, the results are only rows of 2, 3, 4, 7 and 9
How can I do it?

A B C D E F G H I
1 1 5 23
2 32 56 32 56
3 3 6 7 3 6 7
4 5 33 5 33
5 63 71
6 11 84
7 334 97 12 334 97 12
8 224 57
9 13 89 43 534 13 89 43 534

[FDibbins]

If you had intended to upload a sample workbook, I think you forgot to add it

If you did not intend to upload a sample workbook, I suggest you do, showing a small sample of what you are working with, and what your expected outcome would look like.

[soleimani1967]

Sorry. I have not permission to upload a photo. Let me try to upload attached excel file.

[samba_ravi]

F1=IFERROR(IF(COUNTBLANK(INDEX($A1:$D1,MATCH(1,INDEX(--($A1:$D1<>""),0),0)):INDEX($A1:$D1,MATCH(99^99,$A1:$D1))),"",INDEX(INDEX($A1:$D1,MATCH(1,INDEX(--($A1:$D1<>""),0),0)):INDEX($A1:$D1,MATCH(99^99,$A1:$D1)),COLUMNS($F1:F1))),"")

Please Login or Register  to view this content.

OR
=IFERROR(IF(SUMPRODUCT(((FREQUENCY(($A1:$D1<>"")*COLUMN($A1:$D1),($A1:$D1="")*COLUMN($A1:$D1)))>0)*1)-(COUNTBLANK($A1:$D1)>0)=1,INDEX(INDEX($A1:$D1,MATCH(1,INDEX(--($A1:$D1<>""),0),0)):INDEX($A1:$D1,MATCH(99^99,$A1:$D1)),COLUMNS($F1:F1)),""),"")

Please Login or Register  to view this content.

Try this and copy across

[soleimani1967]

Thank you very much for your answer. Your formula as well as works.