data transformation

  1. B

    Power Query - Transforming Messy Data

    Hi. This is my first post. I have MANY spreadsheets that have been formatted for print and I am working to combine and automate these files for easy retrieval and EDA. The files are formatted like this: I have a process to get to the data in the format that I want, but it is clunky and...
  2. Z

    Extract 1-N value(s) from a string of text in 1 cell - multiple extraction values in separate tables (excel formula needed)

    Thank you in advance for the help! ? After extensive forum research, I decided to post since I was unable to find a comparable problem/solution. Summary I need a formula that can extract a value from within a string of text based on a list of multiple criteria to look for (e.g. if value 1, 2...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...

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