LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dan
 
Posts: n/a
Default Fields in a record are on the next line

I have a SS with six fields as follows:
Record 1-
A1, B1, C1, D1, A2, B2

I want to move A2 to E1 and B2 to F1 so Record 1 is on one line.
The present structure now is first record:
A1 B1 C1 D1
A2 B2
Line 3 Blank line and the next line (4) is the second record.
A4 B4 C4 D4
A5 B5
Line 6 Blank line
etc.

There are 2600 records like this. How can I correct this problem, automated,
if possible.
Thanks,
Dan

 
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
unexpected line breaks in .csv mwarner Excel Discussion (Misc queries) 2 July 29th 05 04:20 AM
flip spreadsheet data from row records to column record fields Wasan Excel Discussion (Misc queries) 1 May 27th 05 10:05 PM
flip spreadsheet data from row records to column record fields Peo Sjoblom Excel Discussion (Misc queries) 0 May 27th 05 09:52 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 12:43 AM


All times are GMT +1. The time now is 03:57 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"