Import data and set it in different columns

jurgen · Feb 15, 2015

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 · Feb 16, 2015

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-24c8ffd6d2ff5b45792f1baccf09ac8d.r61.cf1.rackcdn.com/02_15_15a.xlsx
http://805fbd0dee7e8ba6e8e2-24c8ffd6d2ff5b45792f1baccf09ac8d.r61.cf1.rackcdn.com/02_15_15a.pdf

Import data and set it in different columns

jurgen

New member

Attachments

Herbds7

Banned