transformation

  1. D

    Transform text in cells in to table (VBA)

    Hello, dear VBA masters Does anybody know how to transform text in cell into table using VBA I have a list of our customers with their contact information. The emails and phone numbers are being stored in the cells. I need to extract them and create the table and use them / update and etc in...
  2. B

    Having to restructure table to a strange format, need ideas on how to do it in bulk

    I have a set of data as shown in the table below that I need to showcase in the format as shown in the 2nd table. But a little background first: In the table below we used a typical format for customer data, where each unique combination of data had its own row, so if Customer 12345 had US...
  3. B

    Data Transformation: Transpose Rows into Columns

    I'm looking to transpose a spreadsheet that consists of a column with an ID for the whole row of data, followed by data fields listed in a typical column/row setup, similar to the table below. And for background, my particular data set has thousands of rows and about 20 or so columns. <tbody>...
  4. C

    Transforming irregular paragraph-style data into Excel

    I've been tinkering with this problem for a while, but haven't been able to make much headway; I'm sure there's probably a simple solution I'm missing. I have a .txt dataset of the form; ID number Name Address1 City Tel ID number Name Address1 Address2 City that I've been trying to transform...
  5. S

    Data transformation and Transpose in Excel

    Hi There, I am just starting with advanced excel now and have following problem - <tbody> Primary set of data Options Product Quantity Price Option 1 Product 1 1 10 Option 1 Product 2 1 10 Option 1 Product 3 1 10 Option 1 Product 4 1 10 Option 1 Product 5 1 10 Option 2 Product 1...
  6. H

    VBA for update a cell based off another cell

    Hi I am unable to get my macro to work to update one cell based off another cell. I need " Escalated to Issue" cells in Column N to transform "Risk" value cells in Column H to "Issue" value cells in Column H. Can someone help :) This is what I have Sub Test() Dim LastRow As Long Dim i...
  7. F

    Data transformation help - transaction data currently in columns needs to altered

    Hi guys I have a set of data, pulled from Google Analytics in the following format: Transaction ID | Product Name 1 | milk 1 | bread 2 | jam 3 | bread 3 | honey I need to transform this data...
  8. F

    Transform an Excel sales table with multiple monthly sales column into an Access DB

    Getting sales volumes and quantities from a SAP-based system into an Excel sheet, I'm looking for an easy way (VBA or function) to transform those data into an Access DB. The actual format of the data is looking like this: <tbody> Material-ID Product segment Factory Sub-group 1 Sub-group...
  9. D

    Advanced/Expert: XML+XML integration to Xlsx batch process

    Hello all, Talking about Excel 2007 on Windows 7. Here is the deal: Let's say I have two xml docs, that, if opened in excel, and opened as an XML table would like like this: #1 Case Info: here's a link to the file- it just needs to become a sheet- no transformation needed...
  10. M

    Format string as date and time for time series analysis

    I want to find a way to change a string to usable date and time values so that I can run time series analyis on them. I have extracted printing records, each with "timestamps" from poster printers, but the data is unusable as it is. What I get is a string(well, thousands of them, in a column)...
  11. B

    Challenging Excel Question

    Hello everybody, I posted this question a few days ago and haven't gotten any replies. Not sure if this functionality is just too hard to do in Excel or if I wasn't very clear in what I'm trying to get the spreadsheet to do. Any help would be appreciated! I am working on a project in Excel...
  12. D

    transforming column data to rows on a new worksheet

    Hi I have a spreadsheet as follows: Col A: phone number Col B: text msg. So data might look like: Col A.......Col B 99998888 Good Morning Robert 77776666 Greetings Mary I want to create a single-column text file which would present the above data as: 99998888 Good Morning Robert 77776666...
  13. S

    how to tranform data in Access - urgent

    I have a big data in the following format (Headings) ProjectID ; Jan ;Feb (Data row 1) A; 1 ; 2 (Data row 2) B; 4 ;Null I want to transfer this data in the following...

Some videos you may like

This Week's Hot Topics

Top