How to condense data to single rows on a different sheet

You can use a helper column in the Raw Data sheet (e.g. column FB), with this formula in FB2:

=IF(T2="","-",MAX(FB$1:FB1)+1)

Copy this down to the bottom of your data.

Then you can use this formula in cell A11 of the Desired Results sheet:

=IFERROR(INDEX('Raw Data'!FA:FA,MATCH(ROWS($1:1),'Raw Data'!FB:FB,0)),"")

and this one in G11 of that sheet:

=IFERROR(INDEX('Raw Data'!T:T,MATCH(ROWS($1:1),'Raw Data'!FB:FB,0)),"")

Copy these two formulae down until you start to get blanks.

Hope this helps.

Pete

EDIT: You will need to format G11 as General before you put that formula in.

Pete, I have 2 follow-up questions for you.

#1 - In my example, I had (6) "1"s, (2) "2"s, (6) "3"s, etc in Column FA. Will your helper column formula
[=IF(T2="","-",MAX(FB$1:FB1)+1)] work if I have fewer or greater number of "1"s?

#2 - Your solution works beautifully on the rows corresponding to the rows you made numeric. However, I need to pull some data from rows that are a "-" versus numeric (computed by your helper formula). Do I need to make a 2nd helper column for those rows or change my methodology entirely?

Thank you!

The answer to question 1 is YES, but it is easy enough for you to try it and see.

I'm not sure what you mean by question 2, as you get a hyphen on the rows where column T is empty, so what would you want to do with those? It might be best to upload another example workbook which illustrates your latest queries.

Hope this helps.

Pete