Data Munging can take a lot of time. Peak® Spectroscopy Software can help. This feature can combine multiple spectra, with no limit, to a single file (a multi-file).
This is very useful when using external programs like Excel, Matlab or Python to process data. Especially valuable for chemometrics applications, this feature creates a two-dimensional matrix of spectra.
In this screenshot of the 'Export to Multifile' tool, twelve NIR spectra of Erythromycin tables have been loaded into a window. Below that is a partial screenshot of the same data in an Excel spreadsheet.
The same data after export with each spectrum in a colum. Column A is the X-axis values.