Questions tagged [column]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
28 views

Windows Explorer: change default columns of the media-variant set of columns (photos, videos...)

When a folder contains photos and videos, explorer switches automatically which columns are displayed. I'm not questioning here whether I like the feature or not, so let's assume I liked that feature. ...
tomoyo255's user avatar
2 votes
1 answer
144 views

How to create a stacked column chart where each category has unrelated subcategories

I have the following set of data I want to create a column chart with 3 stacked columns(one for each category). The sum of amounts for each category equals 100. The issue I'm having is that the ...
Mohit Singh's user avatar
0 votes
0 answers
18 views

Word: Autonumbering IF other column not empty

I am at a little loss currently. I simply want word (MacOSX) to auto number in column two (See picture attached) if there is text in column three. My Table is basically one line with four columns ...
ActuallySmithy's user avatar
0 votes
0 answers
25 views

How do I extract a single list of 3D spatial coordinates across 2 different sheets that link the 3 cartesian planes?

I am using Excel to draw an ellipsoid that is rotated by 15 degrees. What I want is not a 3D plot of it, but I want to get a list of all the coordinates that share a certain criteria. An example is ...
Haziq Bin Yazid's user avatar
1 vote
0 answers
27 views

How to add additional column types in Windows Explorer's column quick menu permanently? [duplicate]

I want to add some useful column types in the quick menu of Windows Explorer to not go through very long and bothersome process of scrolling through thousands of types in Choose Details window. I want ...
ScienceDiscoverer's user avatar
0 votes
1 answer
26 views

Excel Formula that copys Column Title based off related data within row

I am looking for a formula to represent what is in the highlighted section of the excel sheet. For example, for invoice 4/1/2022, i would like a formula for "payable for" that lists (1)...
jcicea96's user avatar
0 votes
0 answers
88 views

Different text column shading in MS Word

I'm trying to shade columns in different colors but just can't make it. It's either that last line of one column is part of the next paragraph, so it picks up the color of the next column: Or it's ...
Cornelius's user avatar
  • 119
2 votes
1 answer
1k views

How to tell Outlook not to auto resize the columns of a table

I'm having a very frustrating experience with MS-Outlook, while creating a table inside an e-mail: I have some text, separated by pipe characters, and I've chosen the "Convert text to table" ...
Dominique's user avatar
  • 2,071
0 votes
1 answer
80 views

How do I use a cell reference as a column in a table reference?

Say I have a table "Data" (created with the "Format as table" button, with headers). In another table (say "Table"), I have a column ("Target column") that has ...
Joseph Doob's user avatar
0 votes
0 answers
95 views

What is the strongest means to force MS Word to not underrun a minimum table column width

As is generally known, desired column widths in a Word table can be set in the table properties individually for each column in centimeters or percent: However, experience shows that Word does not ...
David.P's user avatar
  • 498
0 votes
2 answers
534 views

Split one excel column with data separated by comma into many columns

I am using a program called FilterPro to design an electronic filter. The filter has some associated data, which you can export to Excel. In FilterPro the data looks like this, where they use a ...
Carl's user avatar
  • 101
0 votes
1 answer
41 views

highlight row with different colors after date is entered in different column cells

We have a spreadsheet that tracks items by date in different columns. Item sent in column L, we would like it to be one color. but once the second date in entered column R. I am needing the row to ...
jaylene's user avatar
0 votes
0 answers
41 views

How to fill a column getting a substring of another one with a rule

I'm trying to play with the functions LEFT, RIGHT and SEARCH to fill a column with the name of a function extracted from another column, but I don't get any good result. I have a list of functions ...
Víctor Martín's user avatar
-1 votes
1 answer
53 views

Mixing 2 columns in excel

Good Morning I'm trying to "combine" two columns in Excel. Not concatenating them, but "mixing" the result For example, I have these 2 columns: Column 1 Column 2 a 1 b 2 c 3 ...
Marcos C's user avatar
1 vote
3 answers
205 views

Win10 Explorer Dimension Column Blank

Just noticed that my explorer in Windows 10 doesn't show the dimensions of my images or videos anymore. Explorer Example: I remember having the Width, Height and Dimension columns working before but ...
Hetsig's user avatar
  • 33
2 votes
0 answers
70 views

How can I set the column width on a given column in multiple opened Excel files at once?

I have 10 opened Excel files. Each of them contains one spreadsheet. How can I set the column width on a given column in multiple opened Excel files at once? I use Excel 2205 on Microsoft Windows 10.
Franck Dernoncourt's user avatar
0 votes
1 answer
2k views

Notepad- Select only one column

I want to select only one column in my txt file. This is the sample of my file, its contain about 15k line i only want to select date column how i change a copy paste only on column... Date ...
saqib's user avatar
  • 1
0 votes
1 answer
30 views

Why doesn't the left column come down in ms word 2016?

I want the left column to be full. Why does the left column not come down? Any Suggestions?
sam sam's user avatar
1 vote
0 answers
52 views

How create increment column in visidata from a set value, not for 1?

If I have I frame with 10 rows, and I create a new column with za and then use gi I get a range column from 1 to 10, but instead of that I want to get a range column from 15 to 25. How can I get that?
Ferre Leon's user avatar
0 votes
0 answers
52 views

Excel - How to combine columns (without concatenating them) from multiple files

I have multiple CSV files, each containing several columns, but only one of interest, column B. It's a column whose header is "Results" and each row in the column contains numeric data. For ...
AF2's user avatar
  • 1
0 votes
1 answer
44 views

Pivot calculated field of variation

I want to create a pivot graph that shows the variation (%) in number of road accidents from year to year+1. I need it to be pivot because I want it to be refreshable if data change. My data is a list ...
Michele Cordini's user avatar
1 vote
1 answer
267 views

Excel Pivot Table - Change Columns using Filter

I have a pivot table and values separated by a signal flag (0 or 1). I many different signal types (columns) to use. Question: Instead of creating a new pivot table for each signal, is there a '...
Tony's user avatar
  • 11
0 votes
1 answer
1k views

List.Sum in Power Query is not ignoring null values

I added a column with this code: = Table.AddColumn(#"Changed Type", "Total Quantity", each List.Sum( {[species_males]+[#"species_females-mixed"] })) List.Sum is ...
Susie Derkins's user avatar
-3 votes
1 answer
114 views

Turning a string of text into individual rows [closed]

I have a series of letters in Excel I would like to turn into individual rows. Is there a simple command to do this instead of using text to column and separating through each one. The list is as ...
wobble's user avatar
  • 1
1 vote
1 answer
91 views

Order file by colum where column is a date

I have a file in the following format 222 aaaaa 2021-12-24 333fd bbb 2021-09-1 444 cc 2022-01-16 555 zzz 2021-08-21 6666 www 2021-09-5 777 yyy 2021-03-14 888 xxx 2021-11-27 999 ffffff 2021-12-4 I am ...
xavi's user avatar
  • 13
0 votes
0 answers
28 views

Value based on whether a column equals a constant

I have a list of values "New, Pending, Confirmed" and columns: date and details. I would like to calculate: x= IF details="New" THEN get(date) y= IF details="Pending" ...
mrshampton's user avatar
0 votes
1 answer
2k views

Convert a columns in Row into a comma separated list

I have this example : And want to convert it to this comma separated as CSV like this:
Samoo's user avatar
  • 1
2 votes
3 answers
1k views

Two columns pdf from markdown with pandoc and lua script

I want to render a two columns pdf document using markdown fenced divs. The minimal example is this : :::::::::::::: {.columns data-latex=""} ::: {.column width="40%" data-latex=&...
ChrisAga's user avatar
  • 141
1 vote
3 answers
3k views

How to split table vertically in MS Word?

I want to create a table with 4 columns and many rows in MS Word 2013. I want to split the table vertically into 4 tables close to each other (e.g. 10 mm distance to each other). I saw some tutorial ...
asad's user avatar
  • 141
-1 votes
1 answer
35 views

MS Excel: Multifilter / Check which strings are already present in another column

I have two separate, big sets of data (+25k rows): YEAR CCS KPF YEAR MMS MS CCS and MMS each denote string variables. How can I identify, which string is in which list already? I want to get rid of ...
Maximilian's user avatar
2 votes
3 answers
156 views

Excel - Divide One Column Vector Into Several Line Vectors

I am currently struggling to find out how a long column vector in excel can be divided into several line vectors. E.g. % one long column vector 20,857 20,888 14,938 0,01 20,872 20,825 14,992 0,007 20,...
Timon's user avatar
  • 67
0 votes
2 answers
106 views

Excel - how to make a full column autosum

I need in column D the total of column A, B, and C that in D1 i should have =SUM(A1:C1) in D2 I should have =SUM(A2:C2) etc. and it should continue the whole column by it self Thanks!! M.K.
M. M. K.'s user avatar
0 votes
2 answers
75 views

Excel data extraction from column

I have data from hospital on patients deaths. The data is not arranged properly, the data is as in link below All the dates should in either column DOA (H Column) or DOD (I Column) or MB (J Column) ...
siri's user avatar
  • 3
0 votes
1 answer
23 views

How do I keep the cell, but change the date for a summary column it's linked to?

I have a workbook with a month's data. Each day is tabbed on the bottom. The data for each day is entered in a row. At the end of the month I have spreadsheets that do a monthly summary of specific ...
Booleyhitt's user avatar
1 vote
1 answer
528 views

What does # mean in Windows Explorer column?

What does # mean in the Windows Explorer column? I've never seen something written in that column.
imida k's user avatar
  • 219
0 votes
1 answer
108 views

Inconsistent Column Range

Created a macro on a table with rows which auto expand depending on what is input. The original range of column D which i am working on is D2:D12. On some occasions, the range will go beyond D12. It ...
Teodros IV's user avatar
0 votes
1 answer
147 views

How to subdivide Excel Column?

I'm a beginner in Excel and need some help with creating a table. How would I subdivide the header of a column into two columns underneath it that could each contain data? That if, if I have a header ...
Gryffin's user avatar
  • 11
1 vote
1 answer
27 views

Quickly inserting columns to many locations in a Word document at once

I have a multiple choice exam I've written in MS Word 2016 with the following question format: 1. Question text that is usually long enough to cross the entire page A. Answer Choice 1 B. Answer ...
theforestecologist's user avatar
414 votes
11 answers
328k views

Selecting columns in Visual Studio Code

Does Visual Studio Code support selecting columns of text? I have not yet found this feature, so I am wondering if it is hidden somewhere. I am familiar with holding down Alt while selecting text, but ...
ChiliYago's user avatar
  • 5,035