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

Lopez, Ahiezer 236 Reputation points
2023-05-02T22:07:15.91+00:00

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

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

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 21,676 Reputation points Microsoft Vendor
    2023-05-03T08:41:47.7366667+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.