let’s use Power Query to scrape web data from List of Indian States page on Wikipedia.
On that page, there is a historical census data table (depicted below) and we will connect to it from Power Query. Once we have the data, we will unpivot it to tabular format for easy analysis.
Data for this example - WikipediaPlease use the URL - https://en.wikipedia.org/wiki/List_of_states_in_India_by_past_population for this example.