Mysql Views to be created

I have 138 Columns with 365 days are rows. Each day any of 138 columns may have some numeric value, I want to create a view so that I can filter or search sales done on specific item (column value) for the year etc. You need to connect to my desktop for accessing the database. New View should have 3 columns like Date Value Sale Amount Value Column will have the values of all original column names found in the table. Example say if original column is like this: Date program1 program 2 2/2/2018 1000 3/3/2018 1000 4/4/2018 200 200 I want new View to be like this Date Value Sale_amount So that I should be able to generate report like show me all sales generated from Program1 etc