# I want to filter and change an Excel table with empty entries in column B **URL:** \ **Category:** Questions\ **Tags:** iterator, excel, filters\ **Created:** [December 18, 2024, 7:52am UTC](https://community.make.com/t/i-want-to-filter-and-change-an-excel-table-with-empty-entries-in-column-b/64323 "2024-12-18T07:52:50Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Ralle\_tb](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@Ralle\_tb](https://community.make.com/u/Ralle_tb)\ **Post date:** [December 18, 2024, 7:52am UTC](https://community.make.com/t/i-want-to-filter-and-change-an-excel-table-with-empty-entries-in-column-b/64323/1 "2024-12-18T07:52:50Z")
I do have an Excel table. There are about 1000 rows with different columns. I want to filter all rows without a value in Col B. THere I want to set an automated value in it, for example (to simplify) the now timestamp. I tried to use a “List Worksheet Rows” with a filter on it and an iterator after that. But I don’t see a way, to to update the filtered columns / vlaues. Can someone help me? Thanks! ---
**Author:** ![dilipborad](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/dilipborad/32/53211_2.png) [@dilipborad](https://community.make.com/u/dilipborad)\ **Post date:** [December 18, 2024, 10:35am UTC](https://community.make.com/t/i-want-to-filter-and-change-an-excel-table-with-empty-entries-in-column-b/64323/2 "2024-12-18T10:35:46Z")
Hello @Ralle_tb, ### Understand the Basics In a Make, there are a couple of modules that work as [Specialized Iterators](https://www.make.com/en/help/modules/iterator#specialized-iterators-935214). It means when you use and iterate the data without using the Iterator itself after getting multiple results this is called **Specialized Iterator**. ### Solution I’m not sure whether **“List Worksheet Rows”** works as a **Specialized Iterator** or not. If yes then directly use your next modules it automatically works as how an iterator works. If it’s not a **Specialized Iterator** then use **Iterator** Immediately after **“List Worksheet Rows”** , then do your further module integration. **Then set your filters based on Iterator values.** I hope this solves your issues. If not then share a screenshot with your used data. * * * 💡P.S.: Always search first, Check [Make Academy](https://community.make.com/t/make-academy-course-overview/29699). If this is helpful, [Mark Best Answers as Solutions](https://community.make.com/t/mastering-the-make-community-mark-best-answers-as-solutions/4685)✅ and give 👍 If you need expert help or have questions? Contact or comment below! 👇 ---
**Author:** ![Ralle\_tb](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@Ralle\_tb](https://community.make.com/u/Ralle_tb)\ **Post date:** [December 18, 2024, 8:19pm UTC](https://community.make.com/t/i-want-to-filter-and-change-an-excel-table-with-empty-entries-in-column-b/64323/3 "2024-12-18T20:19:54Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/b/6bb48e92f4ebde8396a94af74d2d767b936be08b.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/2/c2ed6a79877aed8a56529130b7725e4ded1ead13.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/7/c787c93d776c5ce0f820549fd7bcdfeb0578a9d7.png) I tried it this way without the seperator module. For the time beeing, I’m feeling like no idea, what I’m doing here: 1. I tried a filter but it didn’t word. Hope I will see this later by myself 2. The Excel list seems not to iterate 3. I don’t know how work with the row id. Now in this case, there appears an runtime error in the end Thanks for help ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [March 18, 2025, 8:31pm UTC](https://community.make.com/t/i-want-to-filter-and-change-an-excel-table-with-empty-entries-in-column-b/64323/4 "2025-03-18T20:31:44Z")