data manipulation

Hi all! I am using a data scraper to pull info from the web and an struggling to transform it in a way that's easily read. Right now the csv file comes out like this: Title - data Title - data Title - data And then it repeats in blocks like that. What I want is to move the titles into the...

Hello. I have 1100 part numbers in column A, against that in Column B we have some data that has been entered on separate lines within the cell Part Number Origial Part 1 Audi (A3 A4) BMW (5 6 7) Volvo (V50 S40) Mercedes (C S) BMW (5 6 7) Volvo (V50 S40) Part 2 Mercedes (C S) BMW (5 6...

Hi, I just started a new job and my manager has asked me to look into an existing spreadsheet we have. It contains quarterly data from the company's call centre, compiled for a previous project that looked into assessing how call agents performed and achieved KPIs on a quarterly basis. I've...

I am needing help re-arranging data in one sheet in the format of another sheet. The issue is I need one row broken down into multiple rows that all tie to the inventory number associated This the sheet I need to format. This is the format I need to get to.

I have a large list of data - order numbers and items. There could be anything from 1 to 200 items per order. I am trying to convert this so that each order number is a single row, with relevant items listed horizontally. So, each order number would be a record with between 1 and 200 items...

The initial part of my query is similar to some other posts (although I am not adept enough at VBA to modify the code as needed to suit my purposes), but because the second part goes beyond what I've been able to find already on the forum, I thought I'd post the whole question here. I'm working...

Is it possible to automatically apply data bars to pivot table like this? As you can see there are individual data bars for every subcategory (dates) , and they are not related to each other on category level (item) To make it more clear on what I mean, here is how it would look like if I used...

Hi everyone, I have a data manipulation question that seems simple but I can't figure it out! I have a large list of properties which details how (%) the rental cost (Amount) should be allocated/split between various locations (LOC). The data looks like this: <tbody> A B C D E (D*B) F G H...

Hi Folks! I am back asking for your help. I receive a file in the following format. The rows that start with data in Column "A" are part numbers. Below those part numbers with data beginning starting in column "C" are accessory codes and accessory descriptions, pertaining to the part above. I...

So I have 2 fields Problem Work Performed Both can contain similar information, thus both can contain specific info. So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...

hello there guys I'm having trouble passing this data from this format: " Day | 00:15 | 00:30 | 00:45 ... | 23:45 01/jan | 32 | 30 | 40 ... | 45 02/jan | 45 | 50 | 52 ... | 60 " to this format: " 01/jan | 00:15 | 32 01/jan | 00:30 | 30 01/jan |...

Hello Mr. Excel experts! I'm in need of help to manipulate a data report that populates the entire information into one cell ("Text to columns" does not work unless there's some amazing trick I don't know how to use). This is a credit card financial statement data. Below is a small...

I am doing a regression analysis and have some data from a survey. One column is ethnicity. The way the data is set up is: <tbody> Yearly Salary Ethnicity Age 100 Black 25 87 White 24 57 Black 65 94 Hispanic 45 </tbody> But I would like it set up so that each ethnicity is it's own...

I'm still looking for some help with what at first sight looks like some simple data manipulation but it has me stumped! :confused: I have data on books and authors, like this: Author1 Book1 Author1 Book2 Author1 Book3 Author2 Book1 Author2 Book3 Author2 Book4 Author3 Book5 Author3 Book6...

Hello folks, I have the following issue and will be very grateful if you provide some help: I have one sheet which I need to manipulate some data and copy/paste from it (sample below): I need a script which searches for the word 'Open' in column A and next finds the first non-empty cell in...

I am trying to do an upload to let a general ledger system know when checks are paid (reconciled). To do so, I must upload all checks that are not left outstanding on the bank reconciliation. If a check is on the bank reconciliation, I need to remove it from the Bank History report that shows...

I want to change columns into rows. I was not able to get in contact with original programmer. This is not for a business, but strictly for my own learning. The before data looks like this. | A | B | C | D | +-------+------------+------------+------------+...

Hi, I really hope someone can help... I have an issue currently that I have overcome with a 3rd party add-on. I am sure there is a way to do this with a macro, however my attempts so far have failed. I am hoping someone can prove the power of VBA and Macros and enable the removal of the 3rd...

Hi, I'm currently using excel 2010 & possibly upgrade to a later version in a near future. My question is that I currently have a large excel sheet with data look like below (Please note that the common fields are the member id & dependent associate id): <tbody> member Id name dependent...

Hi all, I have a list of applications listed in columns in row 1. Let's say Column A = Adobe Reader, the rows below it list the users with Adobe Reader installed. I'm actually wanting to have the names in row 1 instead of the application name and list the different applications the name...