Can i move data inside my app?

[Tiger1]

I have an APP that gets data from an SQL database. This database updates every minute. In one of the columns there is data i want moved to another column (but i cannot get it moved in the actual database).

Example:

Table: Category
Columns: [Pumps], [MATS], [Re-rents], etc…

In my APP data structure i want to be able to move some items from [re-rents] into the column [pumps] based on their item description.

Is that possible?

Reason: in column [re-rents] there are many MATS and pumps that my company wants the app to show in their appropriate columns (but to move all of them daily in the database is NOT feasible)

[Bellave_Jayaram]

You could consider adding a column that contains the Name of the column (”Pumps” or ”Re-rents”) where it should display and an app formula in the Pumps and Re-rents columns.

[Tiger1]

Virtual?

[Bellave_Jayaram]

Virtual only if you can compute the column name from other column values else it has to be real.