Creating a table – the easiest way possible

I'm working on a website and I need the users to define the columns for a table. There are different types of columns which might be text, numeric, URL, email and so on. So every column has the name and the type. This is a critical step in the service and I need this process to be as easy as possible. Tests showed that our current method, which is text input and a drop down for each column is not intuitively translated in users' understanding to column title and type... I'm looking for solutions, including to buy a component that can let the users do it in the easiest way possible. Thanks for your help guys!!