Thread:RR3 Michael P/@comment-27006659-20170319151020/@comment-25956839-20170505184720

All.Series.Exporter.v2.7

Generated String

=CONCATENATE("|",D2,"||","",F2,"","||","",G2,"","||",H2,"||",IF(I2,"",TEXT(I2,"#,##0")),"||",IF(J2=0,"",TEXT(J2,"#,##0.0")),"||",IF(K2=0,"",TEXT(K2,"#,##0")),"||",IF(L2=0,"",TEXT(L2,"#,##0")),"||","",C2,"")

The generated data e.g.

|1.1||Cup||Suzuka Circuit||West Circuit||||||3,400||700||PSC

Needs to be sorted by even numbers, then odd numbers need to be



So the data looks like this:

|1.1||Cup||Suzuka Circuit||West Circuit||||||3,400||700||PSC |1.2||Autocross||Brands Hatch||Indy Circuit||||||2,300||500||PSC

etc.