data transformation

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...

Some videos you may like

This Week's Hot Topics