latest value in a series of values.

/ 2024-07-02 / Microsoft

I want to go from Table 1 to Table 2 using pivot table or other automatic ways to summarize information.

What is a good way to accomplish this? I would like to do this in a way that is easy to understand for non-technical people to follow (i.e. no installations of additional tools, or coding if possible!)

Table 1 Table 2 CountryStateRatingAgencyDate CountryStateRatingDateUSGA1A12020-01-01 USGA12020-01-01USGA2A12019-01-01 USAL22023-01-01USAL2A12023-01-01 USAL2A22022-01-01 USAL3A12021-01-01

I want to go from Table 1 to Table 2 using pivot table or other automatic ways to summarize information.What is a good way to accomplish this? I would like to do this in a way that is easy to understand for non-technical people to follow (i.e. no installations of additional tools, or coding if possible!) Table 1 Table 2 CountryStateRatingAgencyDate CountryStateRatingDateUSGA1A12020-01-01 USGA12020-01-01USGA2A12019-01-01 USAL22023-01-01USAL2A12023-01-01 USAL2A22022-01-01 USAL3A12021-01-01 Read More

Tags: microsoft