Get rows only from a especific column

(0) Share

Report

Posted on by LH-27111616-0

Hello guys. I'm trying to figure a way to get values from all my rows, but the column has a condiction.

I have a spreadsheet where my rows are topics to check, and my columns is each day from the year. I need to recover only the rows from the actual day. I just need help on how to filter the column.

Exemple:

Date: 27/11/24

Table

Machines	25/11/24	26/11/24	27/11/24
Paper cutter	Working	Working	Working
Disposal machine	Working	Maintenance	Maintenance
Painter machine	Maintenance	Working	Working

Data to return

Machine	27/11/24
Paper cutter	Working
Disposal machine	Maintenance
Painter machine	Working

Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

David_MA 15,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

To get rows where with a filter, all of the rows must contain the value on which you want to filter. How you have your Excel spreadsheet configured will not work because your filter value is in a column header and not in a row. You would need to set up your spreadsheet like this instead:

Date Paper Cutter Disposal Machine Paper Machine

25/11/24 Working Working Maintenance

26/11/24 Working Working Working

You would then be able to filter on the date column.

Was this reply helpful? Yes No
Chriddle 8,713 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

From:

@{outputs('Compose')}

Map:

Machine | @item()?['Machine']

@outputs('Compose_2') | @item()?[outputs('Compose_2')]

Was this reply helpful? Yes No