How can I format this table to account for the different dates and data?

Question

I have data that I would like to graph however the way the data has been entered it makes it difficult to graph when including the dates of the data. How can I best reformat this data to include the dates and the already existing data.

Here is a link to the file.

https://www.dropbox.com/scl/fi/l1wdwwzsy7pa803a919po/Book2.xlsx?dl=0&rlkey=3f4wse58ho4e7k4gcma7d7hwg

Answer 1

Hi @Lopez, Ahiezer ,

What is the amount of data in your table? If the amount of data is not too large, I suggest you use copy and paste the tables to integrate the data. And how the graph should be displayed? kindly share a sample here if possible. From my point of view, you can separately select the table and go to Data >> Get Data from Table/Range, then merge tables using Power Query.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.