Questions tagged [column]
The column tag has no usage guidance.
23
questions
0
votes
1
answer
26
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 ...
- 1
0
votes
1
answer
20
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?
- 1
1
vote
0
answers
6
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?
- 11
0
votes
0
answers
41
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 ...
- 1
0
votes
1
answer
29
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 ...
- 103
1
vote
1
answer
31
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 '...
- 11
0
votes
0
answers
13
views
How to add a searchable column in Teams
i wanted to add a searchable column in Teams.
It would just find the filenames in "Name" column
- 11
0
votes
1
answer
155
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 ...
- 180
-3
votes
1
answer
22
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 ...
- 1
1
vote
1
answer
15
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 ...
- 13
0
votes
0
answers
24
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" ...
0
votes
1
answer
259
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:
- 1
1
vote
2
answers
364
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=&...
- 121
1
vote
3
answers
884
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 ...
- 141
-1
votes
1
answer
29
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 ...
2
votes
3
answers
81
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,...
- 67
0
votes
2
answers
72
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.
- 3
0
votes
2
answers
70
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) ...
- 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 ...
1
vote
1
answer
159
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.
- 219
0
votes
1
answer
57
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 ...
- 19
0
votes
1
answer
42
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 ...
- 11
1
vote
1
answer
21
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 ...
