R
ruhroh88
I've spent 6 hours already, no cigar.
I have some wide sheeeets with this pattern (columns of numbers {i.e.,
repeating rows of numbers like the ones shown})
Column A is blank, Column B is Voltage, Column C is Current, Column D is
Time, Column E is blank, Column F is blank, Column G-I is a different dataset
organized like B-D, J-K are blank, M-O a third dataset, etc.
I tried to cut/paste a bit, but the wrap is a bummer.
I tried to put commas between the stuff from the columns, and so the two
blank columns are represented by ",,," below.
, ,Voltage, Current ,Time, ,,Voltage, Current ,Time, ,,Voltage, Current, Tim
,,4.01E+00,-2.85E-04,0.00E+00,,,4.02E+00,-2.13E-04,0.00E+00,,,3.91E+00,-4.30E-0,0.00E+00
Up to 1200 rows, colums out to IE or so. Variable length columns.
I'm trying to make scatter plots with 'Time" on the x axis and 'Voltage' on
the y-axis.
I need to move Each Time column (e.g. column D) to the left by 3 columns
(e.g. to Column A), column I to column F, ... and column IE to IB.
I realize this should not be difficult.
I tried recording a macro while I did manually select column, , cut, paste:
My manual work did work, but the macro moved nothing. The 'paste' is not OK.
I tried a bunch more stuff that didn't work.
Is this hard?
JonMe
I have some wide sheeeets with this pattern (columns of numbers {i.e.,
repeating rows of numbers like the ones shown})
Column A is blank, Column B is Voltage, Column C is Current, Column D is
Time, Column E is blank, Column F is blank, Column G-I is a different dataset
organized like B-D, J-K are blank, M-O a third dataset, etc.
I tried to cut/paste a bit, but the wrap is a bummer.
I tried to put commas between the stuff from the columns, and so the two
blank columns are represented by ",,," below.
, ,Voltage, Current ,Time, ,,Voltage, Current ,Time, ,,Voltage, Current, Tim
,,4.01E+00,-2.85E-04,0.00E+00,,,4.02E+00,-2.13E-04,0.00E+00,,,3.91E+00,-4.30E-0,0.00E+00
Up to 1200 rows, colums out to IE or so. Variable length columns.
I'm trying to make scatter plots with 'Time" on the x axis and 'Voltage' on
the y-axis.
I need to move Each Time column (e.g. column D) to the left by 3 columns
(e.g. to Column A), column I to column F, ... and column IE to IB.
I realize this should not be difficult.
I tried recording a macro while I did manually select column, , cut, paste:
My manual work did work, but the macro moved nothing. The 'paste' is not OK.
I tried a bunch more stuff that didn't work.
Is this hard?
JonMe