converting data

  1. T

    Converting horizontal data to vertical data with repeating data

    I currently have a report of 8000 plus employees who have 12 rows of data each. each row of data has 3 columns that are represented for each month of the year. This is how my current reporting feature creates the report. the software I need to upload this data into is in the format below this...
  2. J

    Taking text in a long column and converting it into corresponding text in another. New at Excel! Vlookup?

    I have two columns that read: XXHSXX HR XXTRXX MG XXXFXX XG XXHSXX HS XXTRXX MG XXMEXX RU XXHSXX HR XXHSXX XXTRXX XXTRXX .... The above list represents 2 columns. The left column is 400 lines long. The right column is partially complete with 2 letter codes that...
  3. A

    Converting in to mm

    I have been tasked to convert inches to mm in a huge excel document and I am only able to convert once cell at a time and I would like to be able to convert everything at once or a cell range. Converting formula I have is =CONVERT(2.75, "in","mm") Is there a way to use that in a range rather...
  4. powerjak

    VBA Code Needed to Reorganize Dated Columnar Data to Sequenced Row Data

    Raw data is Comma Delimited text file organized Column-wise. For each daily date (oldest to newest), there are various weather data in adjacent Columns. I am only interested in two Columns of data ... the MAX & MIN Temp for each day. I need to process the data and reorganize it Row-wise. One...
  5. M

    Formula to convert values using referencing

    I am struggling to convert some values into other values, depending on what's happened in preceding columns. In the example below, I want to convert any instances of double letters (AA, CC, GG, TT) into either AA or BB. However, the problem is that I want the determinant of whether it's AA or...
  6. I

    Adding Time that is actually in decimal form?

    Somehow data has been collected in dec form and now I have to add it up in like form. I have some time entries in excel I need to add up and show result back in tenths of time. 7.3 is 7 hr 30 min 7.4 is 7 hr 40 min 14.7 is really 8 hour 10 min so I would like to be able to show as a result...
  7. D

    Need Help Converting Data

    After I download data for my real estate reports I need to convert multiple "Map Codes" to a area name such as South Hill. For instance the "South Hill" is made up of 25 map codes that read like "A622/135". I would like to be able to turn all of the map codes into "South Hill" so that my...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top