data transformation

Hi all, I am trying to get Excel to put results from the FILTER function on the same row as my query, as illustrated below: Lookup table: ID DATE CONTENT DATE CONTENT 1 Text1 Text2 Text3 Text4 1 Text5 Text6 2 Text7 Text8 Text9 Text10 2 Text11 Text12 2 Text13 Text14...

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

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

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

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

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

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

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

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

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