How do i clean the data to look like the picture above?

Tableau

OOI MOI 1. Read the dataset population.csv into Tableau. Remove data for countries that don't have Population for the year 2013. Pivot the data to make it a tall (rather than wide) format. Next, clean the data to remove the X in front of the year and hide irrelevant columns. Once this process is done, the first few rows of data in Data Source View should look like the figure below. population.csv Pivot Population Calculation Year Country Afghanistan 17,586,073 1/1/1995 Albania 3,357,858 1/1/1995 Algeria 29,315,463 1/1/1995 American Samoa 52,874 63,854 1/1/1995 1/1/1995 Andorra Angola 12,104,952 1/1/1995 Anguilla 9,807 1/1/1995 Antigua and Barbuda 68,349 1/1/1995 Argentina 34,833,168 1/1/1995 Armenia 3,223,173 1/1/1995 Aruba 80,326 1/1/1995 - 0 X Tableau - Book1 File Data Server Window Help o population(1) Connection Live Filters 0 Add Extract Connections Add population(1) Text file population(1).csv Files Cleaned with Data Interpreter Review the results. (To undo changes, clear the check box.) $ 819342.txt 2 autosales.csv Dropped Members.txt GatheringData(1).txt New Hires 2017.txt E Sort fields Data source order Show aliases Show hidden fields 219 rows # # population(1).csv Country population(1).... X1995 population(1).... X1996 population(1).... X1997 population (1).... X1998 population(1).... X1999 # population(1)... X2000 # population(1)..... X2001 population(1).... X2002 population(1).... X2003 population(1).... X2004 population(1).... x2005 population(1).... X2006 # population(1).... X2007 populat X200 New Memberstxt.txt population(1).csv 8 Sample - Superstore (1).csv & Sample - Superstore23.csv states.txt Afghanistan 17,586,073 18,415,307 19,021,226 19,496,836 19,987,071 20,595,360 21,347,782 22,202,806 23,116,142 24,018,682 24,860,855 25,631,282 26,349,243 21 Albania 3,357,858 3,341,043 3,331,317 3,325,456 3,317,941 3,304,948 3,286,084 3,263,596 3,239,385 3,216,197 3,196,130 3,179,573 3,166,222 Algeria 29,315,463 29,845,208 30,345,466 30,820,435 31,276,295 31,719,449 32,150,198 32,572,977 33,003,442 33,461,345 33,960,903 34,507,214 35,097,043 3: Po New Union American Samoa 52,874 53,926 54,942 55,899 56,768 57,522 58,176 58,729 59,117 59,262 59,117 58,652 57,919 Andorra 54,942 63,854 64,274 64,500 65,399 68,000 75,643 79,060 81,223 81,877 81,292 63,799 13,137,542 64,084 13,510,616 Angola 12,104,952 12,451,945 12,791,388 13,924,930 14,385,283 71,639 14,886,574 11,693 1: 15,421,075 12,023 15,976,715 12,342 16,544,376 12,637 17,122,409 12,903 17,712,824 13,145 Anguilla 9,807 10,063 10,305 10,545 10,797 11,071 11,371 Antigua and Bar... 68,349 70,245 72,232 74,206 76,041 77,648 78,972 80,030 80,904 81,718 82,565 83,467 84,397 Argentina 3! 34,833,168 3,223,173 on 220 35,264,070 3,173,425 02 105 35,690,778 3,137,652 05 17 Armenia 36,109,342 3,112,958 07 276 36,514,558 3,093,820 on non 36,903,067 3,076,098 on oso 37,273,361 3,059,960 02001 37,627,545 3,047,002 01005 37,970,411 3,036,032 0 7 015 38,308,779 3,025,652 0 0 712 38,647,854 3.014,917 38,988,923 3,002,911 39,331,357 2,989,882 Avi.ba 100 101 100 oon 101 210 Data Source Sheet1 4 0 Sahil OOI MOI 1. Read the dataset population.csv into Tableau. Remove data for countries that don't have Population for the year 2013. Pivot the data to make it a tall (rather than wide) format. Next, clean the data to remove the X in front of the year and hide irrelevant columns. Once this process is done, the first few rows of data in Data Source View should look like the figure below. population.csv Pivot Population Calculation Year Country Afghanistan 17,586,073 1/1/1995 Albania 3,357,858 1/1/1995 Algeria 29,315,463 1/1/1995 American Samoa 52,874 63,854 1/1/1995 1/1/1995 Andorra Angola 12,104,952 1/1/1995 Anguilla 9,807 1/1/1995 Antigua and Barbuda 68,349 1/1/1995 Argentina 34,833,168 1/1/1995 Armenia 3,223,173 1/1/1995 Aruba 80,326 1/1/1995 - 0 X Tableau - Book1 File Data Server Window Help o population(1) Connection Live Filters 0 Add Extract Connections Add population(1) Text file population(1).csv Files Cleaned with Data Interpreter Review the results. (To undo changes, clear the check box.) $ 819342.txt 2 autosales.csv Dropped Members.txt GatheringData(1).txt New Hires 2017.txt E Sort fields Data source order Show aliases Show hidden fields 219 rows # # population(1).csv Country population(1).... X1995 population(1).... X1996 population(1).... X1997 population (1).... X1998 population(1).... X1999 # population(1)... X2000 # population(1)..... X2001 population(1).... X2002 population(1).... X2003 population(1).... X2004 population(1).... x2005 population(1).... X2006 # population(1).... X2007 populat X200 New Memberstxt.txt population(1).csv 8 Sample - Superstore (1).csv & Sample - Superstore23.csv states.txt Afghanistan 17,586,073 18,415,307 19,021,226 19,496,836 19,987,071 20,595,360 21,347,782 22,202,806 23,116,142 24,018,682 24,860,855 25,631,282 26,349,243 21 Albania 3,357,858 3,341,043 3,331,317 3,325,456 3,317,941 3,304,948 3,286,084 3,263,596 3,239,385 3,216,197 3,196,130 3,179,573 3,166,222 Algeria 29,315,463 29,845,208 30,345,466 30,820,435 31,276,295 31,719,449 32,150,198 32,572,977 33,003,442 33,461,345 33,960,903 34,507,214 35,097,043 3: Po New Union American Samoa 52,874 53,926 54,942 55,899 56,768 57,522 58,176 58,729 59,117 59,262 59,117 58,652 57,919 Andorra 54,942 63,854 64,274 64,500 65,399 68,000 75,643 79,060 81,223 81,877 81,292 63,799 13,137,542 64,084 13,510,616 Angola 12,104,952 12,451,945 12,791,388 13,924,930 14,385,283 71,639 14,886,574 11,693 1: 15,421,075 12,023 15,976,715 12,342 16,544,376 12,637 17,122,409 12,903 17,712,824 13,145 Anguilla 9,807 10,063 10,305 10,545 10,797 11,071 11,371 Antigua and Bar... 68,349 70,245 72,232 74,206 76,041 77,648 78,972 80,030 80,904 81,718 82,565 83,467 84,397 Argentina 3! 34,833,168 3,223,173 on 220 35,264,070 3,173,425 02 105 35,690,778 3,137,652 05 17 Armenia 36,109,342 3,112,958 07 276 36,514,558 3,093,820 on non 36,903,067 3,076,098 on oso 37,273,361 3,059,960 02001 37,627,545 3,047,002 01005 37,970,411 3,036,032 0 7 015 38,308,779 3,025,652 0 0 712 38,647,854 3.014,917 38,988,923 3,002,911 39,331,357 2,989,882 Avi.ba 100 101 100 oon 101 210 Data Source Sheet1 4 0 Sahil