Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Rearranging the Columns Macro XL2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rearranging data in one column into two columns Constance Excel Discussion (Misc queries) 6 June 5th 07 04:41 PM
Rearranging cells into certain columns thelinds Excel Worksheet Functions 1 September 28th 06 11:52 PM
XL2003 and tab colours Jack Sheet New Users to Excel 5 August 13th 06 08:57 AM
Rearranging columns/rows BernieH Excel Discussion (Misc queries) 1 February 9th 06 09:16 AM
Rearranging Data Help... Jambruins Excel Discussion (Misc queries) 0 February 22nd 05 03:31 PM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"