I have data in a table in a column called Fruit with the following data:
Fruit Lemons cost $99.99 on sale $5.99 Apples are on sale Where are the $65.99 lemons
I want to be able to update the table with a column called Amount and just have the following from the fruit column:
Amount $99.99 $5.99 $65.99
Can this be done?