Hi Rob,
I think you can try LabTalk script. For example, I stored the data in [Book1]Sheet1!, then I can:
1. Select Window: Script Window form menu
2. Copy and paste the script into Script Window
//Activate the workbook that has 150 columns
win -a Book1;
//Activate the worksheet that has 150 columns
page.active = 1;
//Split worksheet
wsplit mode:=col col:=1;
//Loop over every worksheet
doc -e LW{
//Copy column X to the active worksheet
colcopy irng:=[%H]1!Col(1) orng:=!Col(2);
//Swap column 1 and column 2
colswap (1,2);
//Export worksheet to the specified path and name it with the name of the active worksheet
expASC path:="C:\Users\yuki\Documents\OriginLab\User Files\" + page.active$ + ".dat";
}
4. Select the script to highlight it
5. Click Enter key to run the script
Note that you should rewrite the path to specify where the dat file should be exported.
Regards,
Yuki
OriginLab