Transpose data from text file to Excel

Joef

New member
Joined
Jul 23, 2013
Messages
2
Reaction score
0
Points
0
Hi all, new to forum so be gentle with me!

I have a device that logs temperature on several channels and outputs the data to a text file. I import the text file to Excel and the format of the data can be seen in this attachment - View attachment Final Sort.xlsx
I then have to manually transpose the data so that it looks like this - View attachment Raw Data Import.xlsx.

I am looking for a way to automate this through Excel.

A couple of points to note:

1) The time stamp can be rounded to the nearest minute.
2) The information in the top 14 lines is not critical, but would be nice to have.
3) The data from the text file can vary in size from an hour to several days.

I would be grateful for any help with this please. I have a small bit of experience with running macros, but not VBA or Pivot Tables.

Thanks,

Joe.
 

Attachments

  • Sample Excel Format.xlsx
    15 KB · Views: 13
Top