Import data and set it in different columns

[jurgen]

Hello,

I have a datalogger where i get a ".xls" from.
How can i automatic import the data the right way and set the data in different columns ?

See attachement, the test file is the original and the test1 is the way i want it.

[Herbds7]

Excel 2010 with free Power Query and PowerPivot Add-In.
Compatible with Office 2013 Pro Plus.
For advanced, up-to-date users only.
No formulas, no VBA macro.
http://805fbd0dee7e8ba6e8e2-24c8ffd6...02_15_15a.xlsx
http://805fbd0dee7e8ba6e8e2-24c8ffd6.../02_15_15a.pdf