Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, Time ,,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rearranging data in one column into two columns | Excel Discussion (Misc queries) | |||
Rearranging cells into certain columns | Excel Worksheet Functions | |||
XL2003 and tab colours | New Users to Excel | |||
Rearranging columns/rows | Excel Discussion (Misc queries) | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |