data transformation

  1. D

    Data migration between sheets

    Hello, I am stumped. I am trying to come up with code that migrates data using VBA. below i will share some screen shots to hopefully describe the situation better. So this first two pictures are sheet1 and the data points i want to move to sheet2 which is the third picture. The way it works is...
  2. D

    Data transfer from one workbook to another

    Any help would be greatful! Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see...
  3. M

    Power Query data problem

    I'm using Power Query to combine several .csv files into a single Excel table. Everything works fine if I'm importing the files one by one but when I'm using the From Folder selection Power Query replaces umlauts and other non English alphabets with weird special characters. Is there a way to...
  4. W

    Time Series Analysis VBA Transformation

    Hello! I have data from two water pumps - the data is given in start/stop times for the pump activation. So in column A I have dd/mm/yyyy hh:mm:ss and in column B; then "Start"/"Stop". So something like this for each pump... <tbody> <tbody> 30-Jul-11 01:22:42 RUNNING 30-Jul-11 01:28:20...
  5. S

    Need quick help on VBA code to translate data

    Hi, Can someone help me write a code for translating the data from matrix format to a tabular format Example: I have data in the format Col 1 Col 2 Col 3 Col N Row A val A1 Val A2 val A3 val AN Row B val B1 Val B2 val B3 val BN Row C val C1 val C2 val C3 val...
  6. J

    Transforming a weird data layout structure

    Hi, Using VBA... I have sets of data that is represented in this form (comma represents cell separation): 1, data1a, data1b, data1c 2, data2a, data2b 3, data3a, data3b, data3c, data3d How can I transform that data into the following form: 1, data1a 1, data1b 1, data1c 2, data2a 2...
  7. H

    Rows of Data to Column Subgroups

    Hi there, Just wondering if there's an easy way to turn a table of data formatted like this: Country, 1960, 1961, 1962, 1963 Angola:, 10, 12, 14, 16 Benin:, 20, 14, 12, 31 ... Into this: Angola, 1960, 10 Angola, 1961, 12 Angola, 1962, 14 Angola, 1963, 16 Benin, 1960, 20 Benin, 1961, 14...

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