Results 1 to 2 of 2

Thread: Import data and set it in different columns

  1. #1

    Import data and set it in different columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •