I'd like to share my Excel copy-paste / data transformation tool called Pattern Transfer:
The tool allows you to configure source and destination data "patterns" so that you can transform the data structure of many records, quickly and accurately.
I have two data sets - one has total quantity and one has all invoice details (Invoice number, Quantity, Date). I need to extract all invoices which comprise of the quantity on hand. Data set as below:
Table 1 - Quantity on Hand:
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...
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...
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.
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;
that I've been trying to transform...
Hi There, I am just starting with advanced excel now and have following problem -
Primary set of data
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
Dim LastRow As Long
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:
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...
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)...
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...
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:
Good Morning Robert