StaffHi,
A data-driven test will fit your needs. Please read about data-driven testing in the online documentation and try to go through the Data-Driven Testing tutorial again.
The principle of data-driven testing consists in that you first record needed actions over the application using hard-coded data and then replace them with data stored in an external storage.
In your case, you use several variables to store data for each individual column. But this is inconvenient. This does not allow you to run tests for all the test cases at once. As you have mentioned, the same variables is used in each test case, and in order for the test to cover individual test case, you need to modify the variable values. So, unfortunately, your approach is not suitable.
By using data-driven testing, you can create one DB Table variable that will provide serial access to data that is stored in your Excel file. Then you will use this variable in data-driven loop.
