Ugly spreadsheet copy/paste to CSV
convert an ugly spreadsheet copy/paste into a CSV format.
Start file
TIANJIN DALIAN HUANGPU NINGBO QINGDAO SHANGHAI SHANTOU SHENZHEN WUHAN HONG KONG HAIPHONG 885 885 910 860 885 860 1080 860 1040 860 935 1585 1585 1635 1535 1585 1535 1885 1535 1860 1535 1795 1710 1710 1760 1660 1610 1660 2010 1660 1985 1660 1920
End file
TIANJIN,885,1585,1710 DALIAN,885,1585,1710 HUANGPU,910,1635,1760 NINGBO,860,1535,1660 QINGDAO,885,1585,1610 SHANGHAI,860,1535,1660 SHANTOU,1080,1885,2010 SHENZHEN,860,1535,1660 WUHAN,1040,1860,1985 HONG KONG,860,1535,1660 HAIPHONG,935,1795,1920
View Diff
1,47c1,11 < TIANJIN < DALIAN < HUANGPU < NINGBO < QINGDAO < SHANGHAI < SHANTOU < SHENZHEN < WUHAN < HONG KONG < HAIPHONG < < 885 < 885 < 910 < 860 < 885 < 860 < 1080 < 860 < 1040 < 860 < 935 < < 1585 < 1585 < 1635 < 1535 < 1585 < 1535 < 1885 < 1535 < 1860 < 1535 < 1795 < < 1710 < 1710 < 1760 < 1660 < 1610 < 1660 < 2010 < 1660 < 1985 < 1660 < 1920 --- > TIANJIN,885,1585,1710 > DALIAN,885,1585,1710 > HUANGPU,910,1635,1760 > NINGBO,860,1535,1660 > QINGDAO,885,1585,1610 > SHANGHAI,860,1535,1660 > SHANTOU,1080,1885,2010 > SHENZHEN,860,1535,1660 > WUHAN,1040,1860,1985 > HONG KONG,860,1535,1660 > HAIPHONG,935,1795,1920
Solutions by @h_east:
Unlock 4 remaining solutions by signing in and submitting your own entry