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

Lopez, Ahiezer 216 Reputation points

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.

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,075 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 12,001 Reputation points Microsoft Vendor

    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.

    User's image

    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.