Systematize the table in Excel and build graphs

Offering extra earnings. You need to organize the table in Excel and build graphs. What is the essence: there is a chatbot (for example, in a telegram), in it a person sends an emoji for convenience, and then it is all recorded automatically in a single Google table. The ultimate goal is to build graphs. Schedules for 1 day, for a week, for a month, for 3 months and for 6 months. Then, using these graphs, you can track the dependence of one metric on another. To build graphs, the table must be systematized and brought into a single form.
From messages filter emoji, copy together with the dates in a separate sheet and change the value to 1, format make a number.

Here, a person filled in his data for six months. What is in the data: smoking (how many people smoked per day), training (running, rocking, tennis), if you read this message, please report it, then the toilet, sex, the amount of water you drank (!), meditation is also sometimes there. And of course, how many times did a person eat in a day?

The ultimate goal is to build graphs. Schedules for 1 day, for a week, for a month, for 3 months and for 6 months.

To build graphs, the table must be systematized and brought into a single form.

For example, there is the smoking tab.

There is only a toilet, sex, training, drinks, the amount of water drunk and finish smoking, there are not all dates.