Fetch only first level of grouped rows from Excel

[Kausar]

Is there a way to fetch only the first level of grouped rows in an excel worksheet (eg. Luxury Cars, Mass Market Cars in the below data)? As the grouped rows can differ month by month and I do not have a master list of the grouped rows, I have to keep tuning the Filter tool every month.

 

[Laura_Hickey]

I'm not sure whether there's a way of doing this, but an alternative might be to bring in everything from your Excel then join onto a list of only the values you want to bring back from column A?

If you copy from Excel then paste into Alteryx it turns it into a text input, so it might be quicker than updating a filter?

[Robin_McIntosh · Accepted solution]

Here's an option to start with based on the snippet of the Excel file you have.