A column is a vertical line of something within a program. It can be a column of cells in excel, or a column of text in a text editor or document. Columns are vertically positioned and are generally read top-to-bottom.

learn more… | top users | synonyms

0
votes
1answer
6 views

Prevent newline at top of column in Apple Pages?

I've setup two columns in Apple Pages version 5.1. I'd prefer that a newline not appear at the top of a column, as it is not necessary. Suggestions?
0
votes
1answer
233 views

How to grep rows that have value less than 0.2 in a specific column? [closed]

ID RT EZ Z0 Z1 Z2 RHO PHE 1889 UN NA 1.0000 0.0000 0.0000 0.8765 -1 1890 UN NA 1.0000 0.0000 0.0000 0.4567 -1 1891 UN NA 1.0000 0.0000 ...
0
votes
1answer
115 views

Display-only Column Formatting in Vim for Character-Separated Value Files

I would like to be able to nondestructively align columns when I am editing csv files in vim. I know of various ways to tabularize/align columned data in vim, but they all modify the file itself ...
0
votes
0answers
85 views

Can I set the Windows 7 explorer default columns for all folders?

I'd like to see the PATH rather than the Folder in the columns of Windows Explorer (Win 7 pro) and I can do that for the open window I have. I can't seem to make it stick for EVERY Explorer window ...
1
vote
4answers
1k views

How to columnate text with tabs (in vim or on the shell)

I have a frequent need to manually manipulate tab-delimited text for data entry and other purposes, and when i do this it helps if the text is aligned properly into columns. For example (assuming ...
0
votes
1answer
34 views

Unix - Convert Column to CSV

I have the following output from a command in Unix - "10" "30" "u" "hello" And I want it in the following CSV format without the trailing comma - "10","30","u","hello" I tried tr '\n' ',' ...
1
vote
1answer
45 views

Emacs: Single column completion?

TLDR: Is it possible to make emacs use single-column completion? When using emac's completion mechanisms and there are multiple possibilities, then completions are displayed in a separate window, ...
0
votes
1answer
2k views

Excel - can't get the formula to copy correctly

Have an excel sheet. I want B3 = C3 * C2 So far everything is good. I want B4 = C4 * C2 Did these two manually. I have a lot of rows so I wanna copy the formula. The problem is, I select them ...
1
vote
2answers
411 views

Change names in a column in bash

I have a tab-separated file in Linux that looks like this ~$ head list.tab "x" "1" "FUHGF.jnf.m22-1" "2" "HDFHFEY.gfs.d2-1" "3" "KJFGJF.fr.md2-1" "4" "SDFSDIB.gfd.rtl2-1" "5" "FGJFGOB.hgd.k2-5" "6" ...
0
votes
0answers
2k views

Copy Excel column data from one sheet to another

I am trying to build a workbook to track my personnel & their training. I have a master worksheets which i will be editing and subsequent worksheets which will pull data from the master sheet to ...
0
votes
3answers
2k views

Split column into multiple columns--datewise

I have a column in Excel with 3,652 values. How do I split this column date-wise so that I have ten columns, one for each year, starting at a specified date? From comments: I am working with daily ...
1
vote
1answer
149 views

How can I make total commander show actual size instead “size on disk” in the “size” column, while keeping the dynamic view (x.x k/M/G)?

TC shows "size on disk" in "size" column. I can use ShellDetails for instance, but I also want the dynamic size display (x.x k/M/G) that is not provided by the shell
1
vote
1answer
396 views

Multi-editing and column-mode are buggy in Notepad++?

It will probably be better if I tell you how to see for yourself what I mean rather than try describe it verbally. Take an example like this: this is an example line bluh this is a different example ...
0
votes
1answer
127 views

Individual Columns Password Protected

Can individual columns be password protected for separate people, so that others can view information, but only change data in their column?
0
votes
3answers
4k views

Move every 7 columns into new row in Excel [duplicate]

I have a very large data set in Excel; all of the outcome scores are in a single column. I need these scores to be separated into rows so that every set of 7 scores (i.e., scores 2-8, 9-16, etc) are ...
0
votes
2answers
353 views

Split text file by whitespace

I have a very large text file with multiple columns of data. I.e. 1312.4123 asdkofADkofaO213 dakofasdjodas Fri Mar 2013 15:23:11 .. .. .. etc. I wish to split this text file into multiple subsets, ...
0
votes
0answers
214 views

How to get new data to automatically slot into correct column in Excel?

I am trying to move new data into an existing database with set columns. The existing database has a column for every possible type of data, but not all new entries contain all columns. So I can't ...
1
vote
2answers
2k views

Column width option not available in specific worksheets in excel

Hallo dear Superuser members, I have the following problem. I have a excel document with several worksheets. In the february worksheet I can adjust the column width option. I get the double sided ...
11
votes
2answers
1k views

How to display a single terminal in two columns?

When viewing a PDF on a wide screen monitor, the viewer can display two pages one next to the other. Is it possible to do something like this for a terminal window so that I can meaningfully utilize ...
1
vote
1answer
442 views

Excel singlecolumn to multiple columns based on values

I have 1 column like below: AAA 999888 BBB 1111 BBB 2222 AAA 999777 BBB 3333 AAA 999666 BBB 4444 CCC Doit ... Consider above up to a few thousand rows. I want to convert it to below 3 column table ...
3
votes
1answer
309 views

tmux - how-to enable automatic switching from 80 to 132 columns and back

Currently in our terminal based accounting system, clients mostly use putty (0.61) and when a report is viewed in the terminal, an escape code is issued that kicks the screen from 80 to 132 columns if ...
1
vote
1answer
585 views

Removing “snap to column” in Excel 2007

I have a column in Excel 2007 whose width is set to 200. This means that it is longer than the width of my screen. If I scroll the worksheet from left to right, it will move column by column, which ...
0
votes
3answers
131 views

Calculating a sum on an integer column when another column includes the year criteria for the calculation

I have a spreadsheet where the columns contain values as follows: Column(A) B C D E NameA 01/02/2010 5 4 5 NameB 05/06/2011 4 3 ...
1
vote
1answer
245 views

Sort columns next to last column in Linux

I have multiple files: File 1 a 1 2 b 3 2 File 2 a 2 2 3 b 4 3 3 File 3 d 3 1 2 4 e 4 1 1 2 I'd like to sort the files according to the column next to the last column, after sort: File 1 ...
0
votes
1answer
194 views

how to get column markers with free text editors

Can someone please provide some tips on getting column markers to show (vertical lines) when viewing text files with fixed width column based data. (not csv). Notepad++, wordpad any freebie will do. ...
3
votes
3answers
3k views

Terminal pager: How to display a list in columns?

I'm sure it's very simple, but I can't remember how to tell a terminal pager (more/less/pg/most) to display a long list in columns. Since my input is just a list of short elements, displaying it the ...
1
vote
2answers
119 views

MS Excel: How to work with a column chosen by value in header (row1)

I am importing a large dataset from a website and I want to build some summary stats on a new sheet. The column order is not fixed, so I want to be able to (for example) count all the cells with the ...
1
vote
1answer
656 views

Mac Excel 2011: find Items in one column that are not in another column

Hi this is a repeat of the question: Excel: Find Items in one column that are not in another column I have two columns in excel, and I want to find (preferably highlight) the items that are in ...
-2
votes
1answer
63 views

Automatically go to next row when certain number of characters is entered

I am creating an Excel sheet where there is a comments section where the column width is 58 characters. Is it possible for someone putting in comments to have it automatically go to the next row ...
2
votes
2answers
952 views

How do you add Dimension columns in all folders on a Mac?

On my MacBook Pro 17" running Mountain Lion, in Finder I can go to the Pictures (and Movies) folder and, in column view, I can right click on the head of the columns and add 'Dimensions'. The problem ...
1
vote
1answer
1k views

Sorting two non-adjacent columns without affecting any other column

I have two different columns on Excel. I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
0
votes
0answers
95 views

How to create a text file from column and FTP that text file to server

I don't know much about VB and need to do the following tasks. My question in short is "How to create a text file from a excel sheet column and FTP that text file to a server?" Situation: I have ...
4
votes
2answers
3k views

How do I make Visio header rows behave like Excel header rows?

A few times when I was working in Excel with documents that had large amounts of data, as you scroll down, the header (first cell in the column) stayed visible. I don't remember telling it to do this, ...
0
votes
1answer
332 views

Registry (possibly) error in Windows 7 : I can not resize columns in any program except explorer

I experimented with Winbuilder and after some time I noticed that I cannot resize columns in uTorrent, move bookmarks and bookmark folders in Chrome, then cannot resize columns in Comodo Programs ...
2
votes
2answers
17k views

How to merge two Excel columns into one?

Let's say we have two columns/ranges A1:A10 (group A) and B5:B50 (group B) and we need to merge the two into one column in C1:C60 (60 in C = 10 from A + 50 from B) Data in group A & group B can ...
3
votes
2answers
263 views

format stdout as multicolumn text

I'm trying to take some single column data and display it in a tty as columns, much like ls does. Basically, you can think of this as trying to take the output from ls -1 and make it look like the ...
1
vote
0answers
59 views

Can I add a “tag” column to music files and “fill down” to enter the info for it

I want to add a column to Windows Explorer (in Windows 7) such as "Tag" and then fill in the data for that column by some sort of fill down technique (as in Excel) instead of adding info one file at a ...
2
votes
3answers
48k views

How do I separate a comma-separated list into two columns in excel?

I have a long, comma-separated list which looks like this in excel: 401.50,0.027 402.00,0.028 402.50,0.029 403.00,0.031 403.50,0.032 404.00,0.034 404.50,0.037 Is there a simple way to ...
0
votes
2answers
293 views

Efficiently stripe incoming one-word lines onto columns?

Consider a stream of one-word lines such as the stdout of $ echo foo bar baz quux xyxxy thud | tr ' ' '\n' foo bar baz quux xyxxy thud I say "one-word" to indicate there is no whitespace other than ...
6
votes
2answers
2k views

How can I set gvim's window width to 80 columns of text, plus the ones needed to show the line number

I use gvim with set number in my .vimrc so it shows the linenumber, plus a space, before every line. If the document has less than 10 lines, this takes 2 columns, If it has more than 10, 3 ...
4
votes
3answers
1k views

How can I automatically adjust the Gvim/MacVim window to the width of my vertical splits?

My overall goal here is simple, but the specifics are complex: I want to maintain each vertical split in my MacVim window at exactly 115 columns, regardless of how many splits I add. The story: I’m ...
1
vote
3answers
3k views

How can I compare columns in Excel?

If I have two columns of data with 10000 cells in each, and only three of the rows are not identical in both columns, how can I locate the different ones (without comparing each pair of cells)?
17
votes
1answer
2k views

How to restore the Process Name column in Process Explorer?

Currently, Process Explorer's window does not show the process name: (When I run Process Explorer as another user, the column displays correctly.) I have tried dragging all the column handlers, ...
3
votes
2answers
16k views

Filter/grep some output only by certain column?

How can I filter some output only by certain column? I need something like this: tail -f logs/access_log | grep -v "200" --only-in-column=1 So I want to see only lines that don't have string '200' ...
2
votes
2answers
3k views

Summing a column in the same column without a circular reference

In Excel you can sum a whole column with =SUM(B:B). But of course you can't use that formula in the column you want to sum, because you'll get a circular reference. Is there an easy way of summing ...
1
vote
2answers
44 views

MS Excel 2007 ref

How to transfer data Row to Columns?
3
votes
2answers
4k views

Excel row-wise multiplication

I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column). 1 3 2 5 4 2 Should become 3 10 8 How can I do that in a formula ...
4
votes
1answer
2k views

Change the format of the date column in Thunderbird

I want to change the format of the "Date"-column in the messagelist in Thunderbird. For mails from today, I want to display only the time, not the date. For mails from before today, I want to ...
2
votes
1answer
11k views

Using Excel, How do I Make a Column of Cells Equal One Other Cell?

I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the ...
5
votes
4answers
2k views

How to display Windows Explorer Column Headers in “List” mode?

Windows Vista File Explorer used to display column headers regardless of whether it was in the Details or List view. However Windows 7 displays column headers only in the Details view. Details View ...