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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top