Moving Data From Column A To Rows

Jan 9, 2008

I have data that is all in column A there are 8 pieces of information.

So client 1 info is listed from A2-A9, client 2 from A10-A17 etc. etc.

I set up A1-H1 to be the headers necessary.

How do I go about moving A2-A9 to A2-H2, then A10-A17 to A3-H3 etc. down through all the contacts which go down to A2400...

View 9 Replies


ADVERTISEMENT

Moving Data From Rows To Columns - Depending On Unique Content In A Field In Column

Jun 24, 2014

I have a worksheet which contains 2 columns which is needed to work my problem.

Unique Work ID and Description

The unique work ID are the same for each description, but there are up to 5 different description associated with each unique work id.

I'm looking for an automated process but where to start to convert the 5 rows in the unique row and 5 column for the descriptions

View 8 Replies View Related

Moving Data From Rows To Columns And Delete Repeated Rows

Apr 16, 2014

removing duplicate rows and move other data frm rows to columns.xlsx.

I am attaching a sample excel sheet showing what I need to do.In the first tab, I have a list that includes duplicate rows (first column only). I want to remove those duplicate rows but I don't want to lose the data in the following columns which can be unique or duplicates as well.

see the desired result tab in the sheet to get an idea of what I am looking for as the end result.

Keep in mind that the actual source file I am working with could have up to 50000 row, and the expected results could be around 2000 rows. So nothing can be done manually.

View 5 Replies View Related

Moving Rows Into Specific Column

Sep 10, 2009

I need to move a number of rows, based on user input
in front of the first column, continuously until it 'flattens out' into one row..
And then do the procedure again for the next row
Kinda hard to explain.. maybe i'll use an example
using this matrix :

View 8 Replies View Related

Moving And Deleting Entire Rows Between Tabs In Workbook And Moving Them Back If Needed

Sep 23, 2013

I have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.

View 5 Replies View Related

Moving Rows Of Data Into 1 Row

May 20, 2014

I'm essentially getting a lot of data at the moment, which has a few orders people have made on my website.

Essentially, think order id, address etc and then all the products the customer has ordered.

However, the part which includes what the customer has ordered creates multiple rows of data, with the order ids etc duplicated. What I need to do is consolidate this into 1 row. So to add additional columns instead of rows.

The reason fro this is I want to mail merge the data into an invoice and mail merges work of 1 line of data at a time. I've attached an example, any way to do this?

(Attached to this post / or linked here: [URL] ....)

View 1 Replies View Related

Deleting Rows And Moving Data..

Jul 26, 2009

I have created a spreadsheet with 4820 rows of data (4821 for computational purposes, the last row being blank) with 5 columns.

1. every third row is blank and it needs to be removed (3, 6, 9,...4818, 4821). Once this is accomplished,

2. I need to move the data that is now found in the even rows, column E moved to the above, current odd row, column F. (ie. E2 to F1, E4 to F3, E6 to F5,...E4808 to F4807...,E4820 to F4819 (however it won't go this high). then

3. I need to delete all the current even rows, as the data I need will be in the odd rows.

View 4 Replies View Related

Moving Data From Columns To Rows

Sep 24, 2009

I have the following spreadsheet with 4 columns of data:

1000001245aMr Fred Blogs
1000001270a1 Blog Street
1000001270bNorwich
1000001270cNorfolk
1000001270eNRx x99
1000001270gThe Manager
1000001270k01603 555 555
1000001270l01603 555 555
1000001270qManager
1000001270xN
1000001270yN
1000002245aMrs Fredilina blogs
1000002270a10 Blog Street
1000002270bNorwich
etc etc for about 36,000 rows.

What I need is for each unigue reference ID (column A),
I need all corresponding data moved up into a single row in serperate columns, something like this:

1000001 |245|a|Mr Fred Blogs| 270|a| 1 Blog Street|270|b| Norwich | 270|b|Norfolk |etc
1000002 |245 |a |Mrs Fredina Blogs |270|a|10 Blog Street |270|b|Norwich| etc

Each entry doesn't nessesarily have the same number of rows.

I would class myself as a beginner VBA bod, but the solution to this one is illuding me a present.

View 6 Replies View Related

Moving Rows Of Data To Another Sheet With Vba

Feb 3, 2010

I have an excel file that contains about 1000 rows of data, from column A to O. Column C contains either the letter A or the letter I, A means Active, I means Inactive.

What I'd like to do is replace my monthly manual task of moving all the I's to sheet2. When completed, the excel file should have two sheets, all of the A's on one, and the I's in the other. The original excel file is not sorted by column C. The end result should have the same row 1, being the header row. There are some additional steps, to save the file to a specific location but I think I could do that once the excel file is formatted the way I wanted it.

View 4 Replies View Related

Moving Data (Addresses) From Rows To Columns

Dec 12, 2008

I have address data all in column A (each paret of the address is on a separate row) which I need to move to separate columns on one row for each address:

ie:

Mr Bloggs (row 1)
123 The Avenue (row2)
The town (row 3)
The postcode (row 4)

Mrs Smith (row 6)
456 The street (row7)
The postcode (row 8)

needs to be: (I have used || to indicate different columns)

Mr Bloggs || 123 The avenue || The town || The postcode
Mrs Smith || 456..... || .......

The problem you see from the above is that they are not always consistent ie. the postcode (zip) isn't always 3 rows below the name for example. Also although generally there is a blank row between each record (this may sometimes be 2) and equally there may also be times when there is a blank line in the address.

Any ideas on how to do this.... I have 1000's of records and really can't afford to go through each one making it consistent before moving it to columns?

View 7 Replies View Related

Moving Data From Multiple Rows To A Single One

Jun 29, 2014

Any macro capable of moving data from multiple row to a single one i have attach a sample file before and after ...

View 4 Replies View Related

Moving Data And Deleting Rows, Part 2

Jan 7, 2010

This is similar to a previous post, in July, which was masterfully solved. I have tried to adapt the previous script, without success. Therefore,

I have copied data from a screen and entered it into Excel 2007, which is attached as 'snohomish sample.xlsx The data starts out (sheet 1) in 8 columns (A-H), and only in the odd rows (1, 3, 5, ...) What I wish to do is the following:

Move 'sheet 1 column B' to 'sheet 2 column A'. This is a date which needs to be in mm/dd/yyyy form.

Move the last 14 digits in 'sheet 1 column F' to 'sheet 2 column B'. This needs to be text so that I don't loose any of the zeros.

Move 'sheet 1 column E' to 'sheet 2 column C'.

Leave 'sheet 2 column D' blank as I will be entering a currency amount after running the module.

Move 'sheet 1 column A' to 'sheet 2 column E'. This also needs to be text as I can't loose any zeros or have it in scientific format.

The rest of the data on sheet 1 is not needed on sheet 2.

I will be entering data in 'sheet 2 columns F-K' after running the module.

I am attaching 'snohomish results.xlsx' which shows what I hope the results to look like (note the sample results are on sheet 1 of a different file).

View 6 Replies View Related

Excel 2003 :: VBA - Only Copying Rows With Data In And Moving To New Worksheet

Oct 3, 2012

I am using Excel 2003.

I have 2 worksheets.

Worksheet 1 is called "Master List Data". Every cell within this worksheet contains a formula so that it matches the cell value contained in a worksheet held within another workbook.

The formula for reference is as follows:

=IF('[CCL Breakdown.xls]MASTER LIST - Active Customers '!A1="","",'[WFX CCL Breakdown.xls]MASTER LIST - Active Customers '!A1) .

e.g.

If Cell A1 on Master List-Active Customer contains no data, Cell A1 in Master List Data would be blank.

If Cell A1 on Master List-Active Customer equals John Smith, Cell A1 in Master List Data would display John Smith.

There are currently non-blank values contained in cells A4:A750. But next week there may be non-blank values is cells A4:A790 (i.e. it will grow each week)

Worksheet 2 is called "Master List Flat. At the moment, I am manually copying and pasting the rows which have non-blank values in cells from Column A from Worksheet 1 into this report (e.g. A4:IV4).

I would like to automate this process and I have created a Macro, but I do not know how to word it so that it will only copy cells with actual data in.

The Macro I have written is below:

Sub IMPORTANDFLATTENDATA()
'
' IMPORTANDFLATTENDATA Macro
' Macro recorded 01/10/2012 by walesb
'
'
Application.ScreenUpdating = False
Sheets("Master List Flat").Select
Rows("4:759").Select

[Code]....

View 1 Replies View Related

Excel 2010 :: Moving Data Organized By Columns To Rows?

Nov 26, 2013

import it into to Stata to do statistical analysis. I always receive spreadsheets like this:

country
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000

[code].....

and I have to manually reorganize it like this to import into Stata:

country
year
value

Benin
1991
20

Benin
1992
254

[code].....

Is there way I can quickly design a macro to do this? The problem is that I generally have a list of about 60 countries, and years from 1991-2011. So, it's really time consuming copying the column of data corresponding to the year, pasting below, repasting the list of countries and the years...then again..then again...then again...I'm using Excel 2010.

View 7 Replies View Related

Moving Data From One Column To Another But Only If Cell Is Blank.

Oct 29, 2009

I need to move data from columns B & C into A without losing current data in column A (see attachment). I'm sure I know how to do this but cannot for the life of me remember how.

View 5 Replies View Related

Moving Data From Multiple Columns To Single Column

Mar 28, 2012

in moving data from multiple columns to a single column. I have attached a sample image from an excel file which details the requirement. The first column contains a qualifier, that should remain constant when the data from columns B to the end move to a single column "B". The number of columns for each row is different, however, there is a maximum number, say 25. As mentioned in the image, when the data from columns B to the end is moved in to column B, column A is retained fixed, to the original value, and the original data below it is pushed below. Any pointers to how this can be achieved by VBA or without VBA?

View 6 Replies View Related

Moving Data Cells From Multiple Columns To Single Column

Nov 14, 2011

I'm trying to work out how to take all cells with data from multiple columns and stack them in a single column.

Here's the history...

I have multiple part numbers in single cells in column A. I perform a text-to-columns function. The resulting part numbers spread across multiple columns (say, B through K). Now I need to get all the part numbers, in their own cells, stacked in column A for one continuous list of single cell part numbers.

Is there a VBA option for cutting only the data cells from Column B-K and pasting the data at the bottom of column A while avioding blank cells?

View 4 Replies View Related

Copying Only Rows With Data In First Column - Skipping Rows With Blank First Column

May 12, 2014

I have 2 columns of data E and F. Column E has 11 different words that randomly repeat, Column F has 10 years of dates, about 1,000 entries (10/11/12 format). Both columns values come from formulas.

I am trying to copy cells E & F to columns K & L starting in row 2 only if there is is data in column E (one of the 11 words) and skipping all others rows. Both the E & F values of tthe row must be copied together, i.e if text is in E45, then copy E45 and F45 into column K and L starting with K2 & L2. This is a task which will be repeated multiple times as data is replaced in columns A-D.

View 4 Replies View Related

Macro To Copy Rows Based On Moving Date And Paste Rows Into Identical Sheet

Jan 28, 2014

I need to build a macro which copies 3 rows every day and pastes the row data into an identical sheet. The three rows will have column "D" as =today(). As the days progress the three rows will change accordingly ( tag to the today's date)

e.g. 28/1/2014
28/1/2014
28/1/2014

I need the macro to recognize the date when pressed and copy the corresponding rows of data and paste them into an identical sheet with the same date. The second sheet is an archive sheet. The date will tick over as per the calendar.

View 9 Replies View Related

Moving Multiple Rows Into One Row (1 Record Has 4 Rows)

Jun 10, 2013

I'm trying to create a .cvs file from an exported excel report, but before I can import it to a database I'd like to have one row per record.

I've already omitted out the headers and footers blank spaces and unnecessary columns from the excel file and I needed to just combine multiple rows into one.

It currently looks like this:

ROW#(1), ID#(1), NAME(1)
ADDRESS(1), ZIP(1)
DOB(1), SOURCE(1)
ITEM(1), CITY(1)
ROW#(2), ID#(2), NAME(2)
ADDRESS(2), ZIP(2)
DOB(2), SOURCE(2)
ITEM(2), CITY(2)
and so on..

I'd like to make it like

ROW#(1), ID#(1), NAME(1), ADDRESS(1), ZIP(1), DOB(1), SOURCE(1), ITEM(1), CITY(1)
ROW#(2), ID#(2), NAME(2), ADDRESS(2), ZIP(2), DOB(2), SOURCE(2), ITEM(2), CITY(2)
and so on...

I can't figure out a macro or a way to do this automatically.

View 8 Replies View Related

Macro Optimization And Moving Text From One Column To Another And Deleting Previous Column

Nov 7, 2009

I am running Win XP and Excel 2003.

I have a macro I found here on the boards written by Lenze to delete an entire row based on what is found in column A. I would like to delete any row where Col. B contains 10 or less characters and I have modified it to do so (or at least I think it does). My problem is that it takes about 12 minutes to run the macro (I have about 50k lines to run through). I was wondering if this is the fastest method or if it examines things other than just column B.

Sub Test()
Dim i As Long
LR = Cells(Rows.Count, "B").End(xlUp).Row
For i = LR To 2 Step -1
If Len(Cells(i, "B")) < 11 Then Cells(i, "B").EntireRow.Delete
Next i
End Sub
After this runs, I am left with Columns A to somewhere around AH. The columns are generally in the format of text followed by a numeric column. An individual text column has the same name through all of the rows. The numeric columns have varied values whether negative or positive.
Ideally what I would like: If a given cell (ie. C2) in Row 2 is numeric, then copy the cell to the left (ie. B2) into (ie. C1) and then delete Column B. I need this to work for multiple columns from B to C, skip D and E, and then from F to AG (and maybe beyond).

View 9 Replies View Related

Calculate Average For Column Based On Moving Start Column?

May 3, 2013

I have a pivot that includes customer data and I need to create an average for each row based on the first populated column for each customer. After one month of units appears for the customer, I need to calculate the average going forward, and if there are blanks after that they should be treated as 0 in the average. Below is an example of my description of the pivot.

Jan Feb Mar Apr
Customer #1 1 1 3
Customer #2 1 3
Customer #3 2 2

So, the average for customer #1 would be calculated from Column B to Column E, and factor column D as a 0 in that calculation. Customer 2's average would start in Column C and go to Column E, and factor column E as a 0 in that calculation. Customer 3's average would start in column D to column E.

View 5 Replies View Related

Moving Rows Between Sheets

May 22, 2008

I have a dropdown list with names of different people: Bob, Jane, Joe, et cetera. I also have tabs at the bottom (sheets) for each of these people. Is it possible that when a name is selected from the dropdown box in column D, say Bob, the whole row (row 10 or whatever) is cut from main sheet and put into Bob's sheet, then the row is deleted from main sheet? If this doesn't make sense (because I stink at making sense), just let me know and I will try to clarify

View 14 Replies View Related

Moving Specific Rows

Aug 17, 2009

I'll try to be clear on what I need to do and hope I can find a solution.
I've found similar threads but I can not edit them for my use so I had to ask again. What I have is a lot of cows, calfs, heifers.

When a calf turns 12 months old , (ex: =IF(A3>11;move_row(sheet_heifers);"")), I need the entire row move to other sheet (heifers). and when the heifer gives births the first time (ex: column- =IF(A7<>"";move_row((sheet_cows);"" ) the entire row needs to move to other sheet (cows). I can do age calculating and the rest well.

View 3 Replies View Related

Moving Duplicate Rows

Dec 2, 2012

I have a workbook called "Data"

In column "C" I have a part number
In column "F:H" I have a description

5432345 3445rt4 er4445ty ddews6789
4352345 sdwe33 dew345e jjkiii567899
1234566 qwert5 ertyu777 uiopl88888
1234566 eedrf44 yuikj776 ggggt44444

When I have a duplicate part number i want the second description to be populated in rows "I:K"

1234566 eedrf44 yuikj776 ggggt44444 eedrf44 yuikj776 ggggt44444

View 4 Replies View Related

Moving Rows Based On Key

Nov 20, 2008

I have data as follows:

id | name
0 | axe
1 | sword
3 | pencil
4 | fist
5 | hammer
7 | gun
9 | rifle

Is it possible to move the rows to the row# shown in the ID?
- e.g. pencil gets moved from row#2 to row#3

View 9 Replies View Related

Moving Rows Into Columns

Jul 13, 2009

I am trying to move row data into column data. Here is visually what I need.

Before:

After (one row of data only):

We are trying to import data into our accounting software but we can't until we get it into the right format.

View 9 Replies View Related

Moving Rows To A Specified Location

Jun 16, 2008

I am trying to do work on a sheet and am getting very frustrated. I have a list of several different data entries that contain a row of information. I need to have the excel sheet move these rows to a different sheet in a specified location. For example, in the first column of the data I have the list of commodities, (sugar, cotton, yen, euro, and copper). Then in the second column I have the price and then the quantity. I want to move them automatically from sheet 1 (where they are entered) to a specific location on Sheet 2. I want Cotton to be in A2, Sugar to be in A20, Yen to be in A30, Euro to be in A40 and copper to be in A50. I would like the data to be cut from sheet one and inserted into sheet 2 so that the sheet can move them every day.

View 4 Replies View Related

Macro For Moving Rows To Other Sheet

Nov 29, 2006

I'd like to write some code to do the following: When the first cell of the row contains an "Y", move the entire row to another sheet (in the same file), keeping in mind that this sheet already contains some rows (so add the row on the first empty row in the sheet). Afterwards the original sheet contains no longer any rows in which the first cell is filled with an "Y".

View 4 Replies View Related

Moving Rows And Columns With A Macro

Jun 5, 2009

I have a massive data file with thousands of lines of data. Each line is a pair, for example

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved