All Questions
50
questions
0
votes
1
answer
23
views
Incrementing values when values changes in different column in excel
i want to change values when id values changes to different in excel
like this
ID
ChangedId
8
1
8
1
8
1
22
2
22
2
25
3
Any help will be thankfull.
2
votes
0
answers
713
views
Open Colon delimited file from command line in Excel
I want to create a shortcut or a command to open a file that uses a colon : as a delimiter in excel.
I know via the UI I can
click "From Text/CSV"
select a file
click Import
select a ...
0
votes
1
answer
298
views
Excel Macro building: How do I pull .csv and .xlsx files from my downloads
I am working on a tool to help my business order products. Right now, We have a tool that pulls all of the .csv files from our downloads folder and add them to one excel work book.
I am trying to ...
2
votes
2
answers
6k
views
Convert comma delimited, key-value pairs in single column into different columns
I have a column in an excel sheet that contains value formatted like the following:
"Key1":"Value1","Key2":"Value2","Key3":"Value3"..
I have many rows of this data. I would like to break these keys ...
1
vote
1
answer
259
views
How to sort number of numeric columns in one go
I have 350 columns. Below is a subset of all the data.
I used "Sort Smallest to Largest" tool. It gives results only for one column. If not, it can sort the first column and other columns will ...
0
votes
1
answer
133
views
Is there a way to make Microsoft Excel 2010 include the *.csv files in its list of default files in the file open dialogue box
I am working with CSV files a lot and have to frequently navigate to different directories that contain CSV files. Whenever I press Ctrl + O to open a CSV file, Microsoft Excel 2010 will not list any ...
0
votes
1
answer
36
views
CSV Not able append text as some rows understood as text and some rows and number
I have a excel with a one column. That is imported from Mangento tool.
One of the row value is
7,81,90
and one of the row value is
71,08,19,11,31,614
First row understood as text however ...
1
vote
2
answers
3k
views
Trying to export single column's data from large CSV file
Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file ...
1
vote
3
answers
2k
views
Separating comma delimited data from one cell to multiple cells when the entry is a live data link
My Excel model imports live data from some trading software. If I insert the following formula, I get the details of current tender offers, which are constantly changing:
=RTD("rit2.rtd",, "...
-1
votes
1
answer
35
views
Place a String separated by commas into the Excel rows
I have a String like this separated by the commas:
id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
0
votes
2
answers
333
views
easily change column structure and data in excel
ok so i have a client who has over 15,000 records in a csv file, with the column format:
full name | email
example of the data they have received is such as:
rex harrison [email protected]
tater smith ...
0
votes
1
answer
274
views
Split csv column to multiple columns, group result in pivot table
I have an excel table in the below format (Pipe separator to show the different columns.)
Project |Team |Phase
Project A |W, X, Y |Initiation
Project B |X, Y, Z, M |Planning
Project ...
1
vote
1
answer
525
views
Excel 2010 does not save in correct file type
Whenever I try to save a spreadsheet as 'CSV (Comma delimited) (*.csv)' it appears to save itself as a CSV but has not actually converted the file type.
As a test, to make sure I wasn't going crazy, ...
4
votes
3
answers
13k
views
How to save double quotes and semicolon in a csv file while opening the file in excel 2010?
I receive a CSV file from sever. The data inside it is delimited by semicolon and it is in UTF-8 format.
For example, the data what we receive is:
"NL 我喜"" mutilple""我喜"
When we open it for the ...
1
vote
1
answer
197
views
Conversion from Excel to CSV Correct Cells with Errors
I have a lot of cells which I want them to be formatted as texts. However according to Excel they are not texts and hence should be corrected to numbers instead. For example, "6814070833E000101" is a ...