Delete Not Available Text Values from Workbook

Hi, how can I just delete the text values in this workbook where it says Not Available? https://app.clay.com/workspaces/670253/workbooks/wb_0sz6ugaxRpWDQC9QBfm/tables/t_0t0bg5ixS4ysTk4kEU4/views/gv_0sz6ugahV3D6yAkmBS3 That workbook is a copy of this one, which has the formulas that produced the "Not Available" values https://app.clay.com/workspaces/670253/workbooks/wb_0sz6ugaxRpWDQC9QBfm/tables/t_0szaay9t77oqp6dPbvM/views/gv_0sz6ugahV3D6yAkmBS3

20 comments

Clay
APP
·
·
To delete text values that say "Not Available" in your workbook, you have two options: Option 1: Filter and delete rows 1. Click Filter above the table 2. Select the column containing "Not Available" 3. Choose equal to and enter "Not Available" 4. This will show only rows with "Not Available" - you can then delete these rows Option 2: Delete the entire column 1. Right-click the column containing "Not Available" 2. Click Delete > Delete Column The filter method lets you target specific cells, while deleting the column removes all data in that column.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Rename, Pin, Duplicate, Delete Column
Philip H.
·
·
Ok, but I do not want to delete the entire row or the entire column
Clay
APP
·
·
To edit individual cells containing "Not Available": Option 1: Direct editing ** Click on each cell with "Not Available" and directly copy/paste the correct value or delete the content Option 2: Use search to find cells 1. Click the Search Bar at the top of your table 2. Enter "Not Available" and press *Search 3. Use navigation arrows to move between matches 4. Edit each highlighted cell individually This lets you target specific cells without affecting entire rows or columns.
Source: Customize your table view | Documentation | Clay University
Philip H.
·
·
I want to get the value blank and then make it possible to edit those cells in bulk
Philip H.
·
·
Do you know what I mean?
Clay
APP
·
·
To make "Not Available" cells blank for bulk editing: 1. Filter for "Not Available": Click Filter above the table, select your column, choose "equal to" and enter "Not Available" 2. Select and clear: Once filtered, you can select multiple cells showing "Not Available" and delete their content to make them blank 3. Remove filter: Clear the filter to see all rows again with those cells now blank and ready for bulk editing This approach lets you target only the "Not Available" cells without affecting other data in the rows or columns.
Source: Hide, Re-order, Sort, Filter, Merge Columns
Philip H.
·
·
Ok, good, and once I filter them to only see "Not Available" cells, how can I then actually delete them without wrecking the table itself? I just want the cells where "Not Available" is to be blank, so that we can run the formulas again with no problem.
Clay
APP
·
·
Once you've filtered to show only "Not Available" cells: 1. Select the filtered cells: Click and drag to select all the visible "Not Available" cells in your filtered view 2. Delete content: Press the Delete key or Backspace to clear the cell contents 3. Clear filter: Remove the filter to return to your full table view The cells will now be blank and ready for formulas to run again. This method only clears the cell content without affecting the table structure or other data.
Source: Hide, Re-order, Sort, Filter, Merge Columns
Philip H.
·
·
Ok, good, but I can only do that ten at a time
Philip H.
·
·
I want to delete them all
Philip H.
·
·
Do you know what I mean?
Clay
APP
·
·
To select and delete all filtered "Not Available" cells at once: 1. After filtering to show only "Not Available" cells, click on the column header to select the entire filtered column 2. Press Delete or Backspace to clear all visible cells simultaneously 3. Remove the filter to return to your full table view This will clear all "Not Available" cells in one action rather than selecting 10 at a time.
Source: Hide, Re-order, Sort, Filter, Merge Columns
Philip H.
·
·
Ok, I tried that, but I was not able to delete the whole column
Philip H.
·
·
I do not quite understand what you mean.
Philip H.
·
·
https://app.clay.com/workspaces/670253/workbooks/wb_0sz6ugaxRpWDQC9QBfm/tables/t_0t0bg5ixS4ysTk4kEU4/views/gv_0sz6ugahV3D6yAkmBS3
Philip H.
·
·
Could you perhaps make a video showing where I should click?
Philip H.
·
·
I do not understand why these workbooks look wrong. The second does not have all my rows. Why not?
Philip H.
·
·
https://app.clay.com/workspaces/670253/workbooks/wb_0sz6ugaxRpWDQC9QBfm/tables/t_0t0bg5ixS4ysTk4kEU4/views/gv_0sz6ugahV3D6yAkmBS3
Philip H.
·
·
Ok, so why does it say that there is only 1 row that did not yet run or which does not have an error?
Philip H.
·
·
Should I do force run 2k rows?

Delete Not Available Text Values from Workbook | Clay