reformatting

All, Need help reformatting a data dump from my work system. Unfortunately when trying to get a dump of orders by day, with customer name, product and quantity, it puts the customer name in the same column!! I need to download 3 months worth of orders, please help! Cheers PS example attached...

I would like to be able to reformat a date string in a workbook. The strings are in the format "15-Feb-08" for instance and I would like to have them read "02/15/2008". How can I use the hyphens as the basis to separate date components and reconstruct the date in a different format? Thanks

Hi all, I'm a bit of an excel newbie and am looking for suggestions for any functions/ scripts that will help with my reformatting problem! I currently have a data set with three subheadings. (Number, Name and Fruit.) Currently each row represents a customer with an individual Number and Name...

Hi everyone, I know there are some similar posts out there, but I’m terrible with understanding macros. Could someone tell me a macro for the following? Here’s an example data set: <tbody> A B C D E F G H 1 Date Status 2 ID First Last Service Group...

I have a change log for Personal.xlsb (many thanks to MrExcel gurus!). It works fine, but I'd like to reformat it (see current/desired here). I'd basically like the output to go from one cell with three pieces of data (author/time/date) to the same data in three separate cells, all on the same...

Hello, and thank you in advance for the help! I have data that I pull and copy into an excel sheet every day. I would like this data to be consolidated and rearranged automatically to make it easier to use. This is what the data looks like when I paste it into excel: <tbody> F G H I J...

I have data that has goes out to the right with Year columns. One record with many year columns. What I need is many records with one year column. I am trying to figure out if there is some way to 'automate' this process. Or at least a way to simplify the process. I have 30 columns of...

Hi all. I'm using Excel 2007. Right now I have several panel data sets (each for a single variable) that I want to merge into one big set of multiple variables. Each set has years 2000-2010 as the list of columns, and the set of rows as state. I want to be able to take the sets for variables x...

Anyone has a neat solution to this reformatting problem? I have a huge data set that needs to be reformatted from A to B. The trick is that students do not necessarily take the same number/type of tests. Thanks! Format A Student ID Subject Score a reading 343...

Hello, I am trying to take a range of cells and reformat them in a different sheet that gets rid of the blank cells. I can't figure out how to do this with a macro since the names of what is in the range will differ and the number of cells with text in them will change as the macro updates.