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
0answers
27 views

Excel Does not Recognize Comma Separated Columns

I have a .CSV file that is populated through a system, and I use MS Excel to open it. When i open the file, the data in each record (Row) are shown in one column only, MS Excel doesn't recognize the ...
0
votes
0answers
15 views

Excel 2010 “lastcell” issue with formula in complete column

I'm currently using a formula throughout a column in an Excel 2010 worksheet. It works fine, but I'm not really using the entire worksheet, I only don't want to have to worry about adding the formula ...
1
vote
3answers
35 views

Insert columns and the formula adjusts with it

Lets say I have a number in cell A1 and a number in B1 and the forumla "=B1-A1" in C1. Now I insert a column to put a new number into the newly made C1 cell and the formula has moved across to D1 but ...
1
vote
0answers
15 views

How to lock the columns settings in windows 7 explorer while under details view [duplicate]

I'd like to lock the "column" settings for individual folders. I sometimes set up specific column settings how I like them for a specific particular folder (eg - a folder with videos - display frame ...
0
votes
1answer
18 views

Make the column buffer independent in Putty

How can one set the horizontal scroll buffer in Putty so that it is different from the size of the window. For example, have the window only display 80 columns but the buffer hold 160 columns. I know ...
0
votes
2answers
42 views

How to compare two columns with other two columns for duplicates in Excel

I need to compare columns C and D with A and B and only if exist same combination of two cells in one row. Hope the image below will explain the situation better.
0
votes
0answers
24 views

Why is it not recommended to use zero in an id column in MySQL?

If you're building out a project from scratch, what are some reasons that one would not recommend using zero (0) in an id column for MySQL? Assuming that the MySQL database/server is in strict mode ...
0
votes
1answer
24 views

How to pivot a column into a row?

I have an Excel document where all the data is in one column and I would like it to be in one row instead. So, A1 remains at A1, A2 to B1, A3 to C1, A4 to D1 and so on until column A only has one ...
0
votes
0answers
7 views

Excel 2010 opening data grouping when entering a formula

When I try to enter a formula in Excel 2010 all the columns that I have grouped/outlined open up. I do not want this to happen. When I open the same file on another computer it does not do this. Is ...
0
votes
0answers
49 views

Microsoft Word 2013 View Page/Column Margins

In Microsoft Word 2013 is there a way to view the margins so I can see where the limits of my current column are (one column or multiple columns)? The closest I have gotten to this is by checking the ...
1
vote
2answers
99 views

Count unique values in column B with respect to column A [duplicate]

I have two columns in Microsoft Excel, A and B. The input is displayed below A B ABC 1 ABC 1 ABC 2 ABC 2 ABC 2 DEF 1 DEF 3 DEF 3 CDE 1 CDE 2 CDE 3 CDE 4 I ...
1
vote
2answers
5k views

Excel: How to Superimpose 2 Stacked Column Charts

I have two stacked column charts (with no gaps between the columns) that have identical X- and Y-axes with same intervals. One graph is displayed in red, while the other graph is displayed in blue. ...
0
votes
0answers
33 views

Single column diagrams in double column pages

I was writing a conference paper, and I wanted to know how to insert single column large images in middle of double column text. Copy pasting the image in the middle really messes up the data and ...
2
votes
1answer
2k views

How to change default column widths in Macintosh Finder?

In Mac OS X Mavericks, I find that when I bring up a finder window showing items in a list with columns, the Name column defaults to being way to wide, I have to scroll to the right to grab column ...
-1
votes
2answers
52 views

How can i add the title column to Windows exploror and not get a blank column?

How can I add a column in Windows explorer which either will display the title tag from a html document or which i will be able to edit? For some reason any column that i tried adding including the ...
0
votes
0answers
30 views

autonumbering in excel - stable along modifications

I would like to have some kind of unique, static and automatic number in an ID column of a table. Unlike this question, I would need it to be stable once it has been set (it should not change with ...
0
votes
0answers
233 views

Viewing Column Numbers

How can I view the column numbers in Notepad++ the same way that I can view line numbers? For additional context, I am working with a fixed width file format.
0
votes
4answers
86 views

Can I create two separate columns in a word file?

I can create two columns in my word file, however I want each column to be separated from the other. What I am trying to accomplish is text down the left side column and pictures on the right side, ...
1
vote
1answer
57 views

select column by number in excel

I have a small issue with excel. I doing transformations for some columns in the dataset. I know the number of the columns I want, but I wasn't able to use them in a formula. For example I want to add ...
0
votes
2answers
48 views

From column to matrix

I have few addresses in a single column. Need to move it to rows as below: name1 street1 city1 state1 phone1 email1 name2 street2 city2 state2 phone2 email2 NAME ADDRESS PHONE EMAIL name1 ...
0
votes
0answers
19 views

“Column Handler” for number of PDF pages in file manager; Also, Acrobat XI

I'm not exactly sure what terminology to use... In some advanced file manager apps (such as xyplorer2, XYplorer, or Total Commander) you can define your own columns for extra file information in ...
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
151 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
92 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
1answer
567 views

In two columns layout, how to keep text in each column separate from the other?

I am editing odt document in LibreOffice Writer. I have the following, very simple layout, it looks like this: I would like to text in each column to stay separate from the other column. So the ...
0
votes
1answer
156 views

How do i change value in filtered cells?

Please could someone help me? I have a spreadsheet full of different vacancies and they go in order of the date advertised but have different departments within that and I need them numbered. I only ...
5
votes
2answers
501 views

Allowing users to unhide (format) only chosen columns

TL;DR, what I want to achieve: Hide some columns which I do not want to show to anyone (check) Hide some columns which I want to show only to some users (check) Set separate passwords for both ...
0
votes
1answer
44 views

I've created a “section” in Open Office Org, but how to I exit from it & continue with my regular page parameters?

Using Open Office Org on my Mac os x 10.5.8, I typed text into my page, using my regular document parameters/margins, then I inserted a "section" so that what I typed in next could be entered in 2 ...
0
votes
0answers
46 views

Replace txt with space in a specific column

I am searching for a way to look into a specific column , and if the there is Char in that column (mostly date) I need to replace it with spaces. Example: 123456789(20140109A). Columen number 10 ...
0
votes
1answer
16 views

Calculating non duplicates

I have below data in three columns A B C 07002 72J217.4 72J217 07002 72J229.5 72J129 07002 72J229.6 72J129 07002 72J229.7 72J129 07006 61E001.5 61E001 ...
0
votes
0answers
73 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
1answer
389 views

How to convert two columns into one column of CSV?

This is how my columns currently look now. They are two columns, with each column having a name. I want something this, as shown below in the expected section, for better processing of a parsing task. ...
1
vote
0answers
46 views

How can I create a PDF with flowing columns?

I need to write a script in OSX that takes my input text files and automatically combines them into a PDF file that has flowing columns - that is to say, where I give it a long chunk of text and that ...
1
vote
4answers
864 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
39 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
0answers
610 views

Plotting multiple xy pairs in Gnuplot from file

I have a data series that I'm trying to plot in Gnuplot of the format: x1, y1, x2, y2 ... xn, yn Where every two adjacent columns represent an xy pair. I'm looking for a way to plot each of these ...
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
315 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" ...
3
votes
2answers
5k views

Mirror column on separate sheet in Excel 2010

I am trying to mirror a column from one Excel sheet to another within the same Excel book. The goal is to have the second sheet update as the first sheet is edited. Basically, as I add/remove rows in ...
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
1k 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
116 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
0
votes
2answers
495 views

Set Width of Multiple Column in Excel

I have a bunch of columns on a worksheet, these columns do not have the same width, But all these columns must have in total a given width. How can I do that, keeping the ratio? So I have this: ...
1
vote
1answer
340 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
111 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
3k 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
1answer
4k views

How to properly align text between table columns in Microsoft Word?

I'm working with a large table in Microsoft Word 2010. It's a pretty simple table, consisting of two colums. In the left column, I have keywords. Those keywords are linked to a specification (portion ...
0
votes
2answers
309 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
169 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 ...