Tweet
I'm working with engine datalogger and after processing the output is a .csv. Currently working with 55 columns (each a different engine parameter), but every log file will have different number of rows (5 second intervals, total time dependent on drive cycle).
I'm trying to build a template that will help sort this stuff out. Sheet 1 of the template file will get the raw .csv pasted into it. Subsequent sheets will be dedicated to engine system groups, so sheet 2 might be "exhaust aftertreatment," sheet 3 might be "fuel system," etc.
What's the easiest single function to have a complete column on sheet 2 match a complete column on sheet 1?
(I understand that I on sheet 2 I could do "='Sheet1'!A:A" but I'd have to drag that down and fill the entire column on sheet 2 every time, and I couldn't pre-fill the template b/c I never know how many rows of data I'll get.
Does this even make sense?
I'm trying to build a template that will help sort this stuff out. Sheet 1 of the template file will get the raw .csv pasted into it. Subsequent sheets will be dedicated to engine system groups, so sheet 2 might be "exhaust aftertreatment," sheet 3 might be "fuel system," etc.
What's the easiest single function to have a complete column on sheet 2 match a complete column on sheet 1?
(I understand that I on sheet 2 I could do "='Sheet1'!A:A" but I'd have to drag that down and fill the entire column on sheet 2 every time, and I couldn't pre-fill the template b/c I never know how many rows of data I'll get.
Does this even make sense?
Comment