How to Select Certain Rows of Data

[BrandonS4]

I am trying to pull in only certain rows of data in a spreadsheet.  I am only interested in column A and the amounts in column B.  The empty rows contain other data that I do not need.  How can I only show the lines I need?  I tried using REGEX but it wasn't working.

USA
Forecast	1
Collected	2
CANADA
Forecast	3
Collected	4
MEXICO
Forecast	5
Collected	6

[T_Willins]

Hi @BrandonS4,

You can use a Filter tool on Field A of !IsEmpty().

[BrandonS4]

This definitely helps.  Next I need to group by country name.  How can I pull out the amounts by country name?

[T_Willins · Accepted solution]

You will need to pull the Country into a separate field.  A Multi-Row Formula tool is good for this as it can look at FieldB and if empty, return FieldA, otherwise copy what is in the row above in the same field (in this workflow the new field "Country").  The data can then be filtered to remove now extraneous rows.  RegEx is a great tool and I use it frequently, but in this case other tools are much easier to use.