data conversion

Hello, I have a power query pulling from a CSV file. I have set the data type in one of the columns as text, but there are errors that claim power query could not convert the data in the column to a number. I have tried refreshing the query. I've tried converting to a different data type then...

Hi All, I have been facing this recurring issue. We need to analyze the spend as per product and SKU by week, months, quarters etc. The dump from the tool is in a raw form and we end up spending lot of time in converting the data into a format which can be further used to apply pivots. I am...

I'm hoping somebody here can help me with my problem as im well and truly fed up with it! :mad::laugh: I have thousands of rows like in the example image below. This record summarises the attendance for a course of treatment. At system level this record is linked to the patient attending and...

Hi everyone, I have a tough issue I need to solve quickly and I really need your help here. I have a DATE column where in some of the records the date appears in Excel formated as GENERAL (aligned to the left in the cell) and I I tried everything to changed it to date but to no avail. The...

Hi everyone. One of our partners don't understand how to usefully present data, and their equipment is generating data usage reports into csv/xls, however are displaying data values in a mix of GB's, MB's and KB's. We need to sort and compare this data, and its absolutely useless in this...

Hi everyone, I was given a spreadsheet where someone typed in 1224 and it was supposed to be 12:24. I have over 1500 of these type of errors. Is there a way to correct them without having to retype each of them? Thanks, Dennis

I am trying to use the below macro to copy HTML into IE10 and paste back into excel in a rich text format The error message is 'Run-time error '438' Object doesn't support this property or method. When I debug it appears to be something wrong with the copy line? Sub Sample() Dim Ie As...

I receive emails from our Form Mail page that clients use to register for our Fitness classes. They look like this....This is the exact way the information comes to me. <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/>...

Hi, I have a data set data shown below in Table 1 (this is just a sample data set, actual data set has 10,000 lines). I need to convert this to the format in Table 2. I figured the best way is to create a query based on Table 1 to get the "subject" hook and then to relate this subject query to...

I have excel file that have the following columns: Sample ID, Analyte Name, Concentration, RSD. These columns are filled down. I would like the analyte names should be the column headings. Then the rows with the sample ID, Concentration, and RSD - these rows are filled in with elemental...

Help!!! Am at a loss :confused: How do i write a macro that would look for a string (Numeric e.g. "999") in colum's 'O' - 'T'? (Columns 15 - 20) If the string is found, i want it (the macro) too copy that entire row to a 'new' sheet (Sheet2) in the same workbook and delete the row from Sheet1...

I thought this would be easy. I can't figure out how to paste a portion of a worksheet so, here's what I have: A B C D E F 1 123 ABC 1 123 Joe Smith 1234 N. Elm 2 123 ABC Tommy Jones 59th Street When I save it as a .txt...