Home > microsoft excel > Is there a way in Excel to split a large file into a series of smaller ones, based on the columns?

Is there a way in Excel to split a large file into a series of smaller ones, based on the columns?

May 6Hits:2
Advertisement

I have a sheet called say detail_data.xls now i want to split this sheet based on columns say column a,j and s in one sheet called chasis. column c, f and r in second sheet called port.

like wise

Answers

Method A.

Open the spread sheet. Choose Save As. Save it as a different name (or in Google Docs, "Make a copy". Open that new copy. Delete the columns you do not want. Save and close. Open the original. Delete the columns that would enable you to make this a different sheet.

In other words... you have excel sheet detail_data.xls. It has 6 columns... a through f. You wish to move a, c, and d to a new sheet. Create a copy of the spread sheet. On the new sheet, delete b, e, and F. On the old sheet, delete a, c, and d. You now have a new sheet with just the columns you wanted.

Method B.

Select and copy the columns you want on a new sheet. Open new sheet. Paste columns into new sheet.

EDIT Unless you read this and you realize that you didn't explain what you really wanted to do, or that you explained it incorrectly...

Related Articles

  • Is there a way in Excel to split a large file into a series of smaller ones, based on the columns?May 6

    I have a sheet called say detail_data.xls now i want to split this sheet based on columns say column a,j and s in one sheet called chasis. column c, f and r in second sheet called port. like wise --------------Solutions------------- Method A. Open th

  • split a large file with mac in command line by contextFebruary 10

    I have been trying to split a large file (some GB) into pieces, I need to chunk the file by linenumber (say, containings about 1M lines each). How could I do? csplit does not work, goes out of memory. Below, an example of the content: 690451 World_Wa

  • How can I split a large file into smaller parts on Windows? June 4

    This question already has an answer here: How to split large file on Windows? 5 answers I want to split a large file ~9 GB by lines, I know split command in UNIX but is there a similar command for Windows? --------------Solutions------------- Check t

  • Split the large files into sub files. How to do this process? December 11

    This question already has an answer here: Break a large file into smaller pieces 2 answers I have a large file in my unix box with 2 Gb. The files contains the xml lines. I want to split the files into say 10 files say each file is now of 204 MB ( ap

  • Split very large files on record borderFebruary 4

    I have to split a very large file into N smaller files with the following constraints: I have to split on record border Record separator can be any character the number of records in the resulting N files should be the same (+/- 1 record) I can just

  • Excel 2003 to Excel 2007 performance on large filesJune 25

    We have a user that uses Excel 2003 for a few of their acturial formulae. At the moment they are using a ESX host VM with 2 gig of RAM and a single core. The issue is that their huge burgeoning spreadsheet (some 35000 rows of intricately linked data)

  • Split a large file into smaller files and then integrate them to get the original fileNovember 8

    How do I split a 7GB (movie) file into smaller files of (say) 1GB, and then (in another Ubuntu computer) integrate them to get the original file (using just bash commands)? --------------Solutions------------- split -b 1G -d bigfile bigfile-part cat

  • What Linux utility can split a large file into a multi-file archive that can be opened on Windows?January 31

    I have a 6GB file which I need to transport on DVDs. I have a Linux system, while the recipient has a Windows system. Is there any way for me to make a multi-part archive to spread the file across two DVDs that can be opened by a Windows user? ------

  • split a large file to new file with unique file namesSeptember 21

    I appreciate your help if some one could help me with a script that could split a file into unique file names. I can do it with sed command eg, sed -n '/scaffold135_/w 135-scaf.txt' input file.txt (time consuming). a smart way to do it, below is how

  • Can I split a spreadsheet into multiple files based on a column in Excel 2007?

    Can I split a spreadsheet into multiple files based on a column in Excel 2007?October 19

    Is there a way in Excel to split a large file into a series of smaller ones, based on the contents of a single column? eg: I have a file of sales data for all sales reps. I need to send them a file to make corrections and send back, but I dont want t

  • Automatically split a sound file into multiple pieces with LogicNovember 20

    I'm wondering if Apple's Logic allows you to automatically split a sound file into multiple pieces based on criteria such as time-lapse (split a larger file into n 2 seconds chunks). I'd rather not pay $499 to find out that it doesn't or doesn't do i

  • How to split and combine files?December 7

    How to split and combine files in Windows? I need to split large files into several small sized files and then combine them after I transfer them to another box. I'm fine with doing this on the command line. --------------Solutions------------- I ten

  • How to split large file on Windows?

    How to split large file on Windows?January 11

    Is there a tool to split large text file (9Gb) into smaller files so that I can open it and look through? Anything usable from command line that comes with Windows (XP)? Or what's the best way to split it? Can I use 7z to create separate volumes and

  • Split a large text fileMarch 4

    I have a large text file grouped with separate headers that I need to split into separate files. For instance the file has headers like this: --Heading 1-- some text text --Heading 2-- more text etc --Heading 3-- asdf text I need to split the large f

  • How do I split a large MySql backup file into multiple files?October 1

    I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB ... Is there a program that let's you split an SQL file into multiple SQL files? It seems like people are answering the wrong question ... so I will clarify more: I ONLY

  • How to split a video file into smaller chunks in Linux? September 1

    Possible Duplicate: Tool like Media File Segmenter for Linux I know that one can use ffmpeg to extract a smallfile.avi from a largfile.avi. But What I am looking for is an tool/command to split a large file into several files of a given size. -------

  • busybox tar or split large file to multiple smaller filesApril 27

    I am running Linux version 3.4.8 on an at91sam9g20. I want to take a large record and split it into multiple files. I have tried a number of methods, but none appear to function correctly, e.g. tar -c -M --tape-length=102400 --file=disk1.tar mytest.t

  • Linux- split large files in smaller chunks and append .txt to the smaller piecesNovember 13

    I have been trying to split a large file using the splitcommand but along with this I need to do the following: split a number of files in a directory add an extension .txt to the smaller chunks I have tried the following : split -dl 10000 "/root/Dum

  • FFmpeg splitting large filesFebruary 1

    I need to split a large video file into multiple pieces quickly and without files with errors. The basic idea is, I have a 2GB video file which I want to change to multiple formats. I have read some encoders can not make use of more than 1 core when

  • Pasting text into Excel without splitting on spaces (or other delimiter)May 8

    I recently used the Text to Columns feature in Excel to split a column of data into multiple columns based on the space character. Now when I paste text into Excel it automatically splits it into multiple columns without using the Text to Columns fea

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 1.040 s.