Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
Excel data file format | Excel Discussion (Misc queries) |