How to condense data to single rows on a different sheet

I have a "Raw Data" sheet with columns and columns of data. It has many blank cells throughout the sheet. I want to condense the multiple rows based on specific variables. In similar past efforts, I used a similar formula (below) with great success:

=IF($A11="","",SUMIF('Raw Data'!$FA$2:$FA$200,$A11,'Raw Data'!T$2:T$200))

It doesn't work this time and I'm not sure why, maybe because my data this time includes text??? I have attached a sample workbook for review. The "Raw Data" sheet contains data in actual column location. Sheet 1 is my desired output and the formula I referenced. Thank you!

Unfortunately I can't. Sometimes they will be "1A", "2D", etc.

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