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 @ltn614:
Unlock 3 remaining solutions by signing in and submitting your own entry