View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Simon Paul Simon is offline
external usenet poster
 
Posts: 1
Default Repeated data into flat file format

Sorry about the title, but didn\'t know how to say it better.

I have 3 columnns of data spread across a speadsheet like this;

Col 1 2 3 Col 1 2 3 Col 1 2 3 Col 1 2 3
xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx
xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx
xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx
xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx xxxxx xxx xx

What\'s the easiest way to get all of the Column 1,2,3 data
into just 3 columns;

Col 1 2 3
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx
xxxxx xxx xx

I need to do this every day, so I\'m not looking for a simple cut and
paste.

After this has been done, the file used as a linked table in Access.