Selecting specific cells based on condition

Is it possible to select cells in a column based on the following condition:

If a date has a value above 0, keep the cell

Else remove cell

Like below as you can see, I would only want to save the dates where there are hours input (ie. 7.5)

The output should look like below:

Workflow

Output

Date Time

Preparation

Accepted answers

I think I got you!

Output:

What happens:

1) Removing columns that aren't needed (Select)

2) Removing all entries without Payroll number (Filter)

3) Transposing the value columns into rows (Transpose)

4) Text Input with custom conversion for the weekdays, these will come in handy when we try to get start / end date (Text Input)

5) Join both together (Join)

6) Formula with Starting-Week plus "Apply" value to calculate the date of an entry (Formula)

7) Summarize to find out "Max/Min" date (Start/End) per Payroll Number (Summarize)

😎 Formula Tool to add AM / PM Columns (Formula)

9) Ordering everything by Start Date (Sort)

10) Select to fix the column order (Select)

Workflow attached. Let me know if I got it right.

Best

Alex

you can use a Filter-Tool to achieve this.

Best

Alex

Thanks for your response, although this does not seem to give me the desired output.

For example, if I try filter out Monday values that is not equal to zero, I get the following:

I am assuming one column must work before I try and filter all columns?

Thanks!