All Questions
Tagged with csv microsoft-excel
495
questions
0
votes
1
answer
43
views
How to make comma elements in Excel sheet be in their own row, with identical data for other columns
What I mean is,
turn this:
| ID || Names |
| 1 ||A, B, C|
| 2 ||A, D, F|
into this:
| ID || Name |
| 1 ||A|
| 1 ||B|
| 1 ||C|
| 2 ||A|
| 2 ||D|
| 2 ||F|
The data I'm trying to transform has ...
0
votes
1
answer
2k
views
How to convert a CSV’s timestamp format?
I am trying to convert a CSV file that returns the time stamp as hh:mm:s.mmm into hhmmssmmm with the added s for second.
For example I pulled a CSV file in which the time came back as 10:15:7.123 but ...
0
votes
1
answer
43
views
Move lines based on ending of previous line
Looking to get some insight as I'm lost on this one. I'd like to move lines based on the ending of previous one. It's a large CSV file that has a comment column that exported in line breaks from the ...
0
votes
1
answer
1k
views
How to insert filename from cell into excel formula?
I have a bunch of .csv files that have IDs that I am trying to insert into a formula. The IDs are all listed in column F. Here is F in my sheet:
F
701
684
128
701
485
701
...
Each CSV file is in a ...
0
votes
2
answers
943
views
How to Convert 2 Columns of Data to Bullet List?
I have a csv of data that exists as a hierarchy.
ColumnA = Parent
ColumnB = Child
There may be multiple children per parent.
I would like to convert the excel data to a bullet list hierarchy. (if ...
0
votes
1
answer
228
views
Manual input column with restricted allowed values in power query imported table
I'm using the Power Query Editor in Excel in order to obtain a table composed of the content of all the CSV files that I put in a specific folder. This table contains a list of bank transaction. When ...
3
votes
2
answers
1k
views
How can we open CSV files that are using single quotation as string delimiter in Excel?
We are working with a set of data that contains all kind of characters (comma, semi-colon, double quotation, tab, etc.). To handle this situation, we are using single quotation to surround the strings ...
1
vote
2
answers
2k
views
Export Excel sheet as CSV, with regional settings
I want to export an excel sheet as CSV, with powershell. The issue I have is that the regional settings are not respected. They say to use semicolon as delimiter, but comma is used instead. If I ...
0
votes
2
answers
2k
views
How to turn column data into csv data?
I've got a bunch of names (around 300), they were filled out as standard text in Excel. However in order to process this data I need to turn it into a list of names separated by commas (a csv). I can ...
0
votes
0
answers
3k
views
Stop Excel from re-interpreting date format on re-opening CSV
I have many large datasets that I am saving in .csv format, the input date values are in Julian format, but the final date format I want is dd/mm/yyyy hh:mm:ss. This part is simple, I just apply a ...
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.
0
votes
1
answer
67
views
Why is Permon data time format is reversing day and month when I open csv in excel?
I have exported perfmon logs into csv.
I open the csv in excel, and the 1st column has the datetime value, so I right click on it and format to select the following custom format: dd-mmmm-yyyy hh:mm:...
0
votes
0
answers
368
views
Excel not opening .csv files
I reorganised my folders in Windows Explorer and when I try to open some .csv files with excel I get an error "Sorry we couldn't find "xyz.csv". Is it possible it was moved, renamed or ...
0
votes
4
answers
26k
views
.csv did not save all tabs
I downloaded a database in .csv and made pivot tables in different tabs.
I saved the file without complications, but when I went to open it, only the tab with the database appeared, the other tabs did ...
0
votes
4
answers
2k
views
How do I batch delete entire rows that do not end with forward slash in CSV file?
I have a CSV file that is too large because it contains file paths as well as directory paths. I need to modify it so it only shows the directory paths but not the files themselves.
I'd like to know ...