Move Specific Data From Row To Column?

Jun 24, 2014

Currently i hav list of info that is long like this.

A 1
B 2
C 3
D 4
E 5
F 6
G 7
H 8
I 9
J 10

How to move row to column example below. Because i want the data to be printed on an a4 paper which can fit around 3 row to save space . If i manually copy paste page by page it is too much.

A 1 D 4 G 7
B 2 E 5 H 8
C 3 F 6 I 9

===

Currently i have macro code which roughly does this.

A 1 B2
C3 D4
E5 F6
G7 H8
I9 J10

Sub test()
Dim rng As Range, m As Integer, c As Range
Columns("c:E").Delete
m = 2
Set rng = Range(Range("a1"), Range("a1").End(xlDown))
Set c = Range("a1")
Do While c <> ""
'MsgBox c.Address

Range(c, c.Offset(m - 1, 0)).Copy
Cells(Rows.Count, "c").End(xlUp).Offset(1, 0).PasteSpecial Transpose:=True
Set c = c.Offset(m, 0)
Loop
End Sub

View 2 Replies


ADVERTISEMENT

Sort / Move Data In Accordance To Specific Column?

May 9, 2014

How to do what I am about to ask takes time and time causing brain overloading. I have made screenshots but I can't upload them. I get red exclamation point with images sizing ~55KB

View 9 Replies View Related

Move Rows With Anything In Specific Column

Dec 16, 2007

I am working on the attached price proposal and need my user to be able to enter a number into column E indicating that that row should be printed on the quote. The 'quote' can be new sheet or another area of current sheet that is formatted to look like letterhead.

View 4 Replies View Related

Macro With Formula To Move Specific Information To New Column?

May 22, 2014

I need a macro to move specific information.

I get an excel sheet with W/C Employer: (whatever) entered below the patient it belongs to in column E. This information needs to move into its own column (H) in line with the above patient information so I can use it in a mail merge to word.

The same thing needs to happen with WC injury date listed in column G. It moves to column I. Then delete the row it was moved from so I don't have an empty row.

Sheet 1 is what I get. Sheet 2 is what I need to end up with.

View 4 Replies View Related

Move Rows Based On Specific Text Being In Column

Mar 21, 2008

I am trying to have rows moved from (Schedule) to (Complete) in the attached workbook. The criteria to have the row moved would be the user-selected "Status" list changing to "COMPLETE" in Column G.

I would like to have the row cut and deleted from Sheet4 (Schedule) once "COMPLETE" is selected from the list in Column G with rows below moving up. The row would then be inserted into Sheet2 (Complete) at the top of the list (Row 7) and rows would move down below the new entry. I would also like to have the formatting remain uniform (every other row fill)

View 2 Replies View Related

Move Specific Data To Another Spreadsheet In The Same Workbook

Jul 5, 2007

What I want to know: Is is possible to have information from one spreadsheet move specific data to another spreadsheet in the same workbook?

for example: I have hundreds of listings of tool measurements.

Date Tool type Measurements


What I want to do is have all the different types of tools and the information from the above line seperated into other spreadsheets. I do not want to sort this information and manually move it I want a formula that will move each applicable tool into that sub sheet. I have tried to use if statements but find that it creates subsheets with the correct tool types but has the spaces in between the parts. how do I eliminate the spaces?

View 9 Replies View Related

Macro To Extract Data From Specific Column To New Sheets Specific Column?

Jun 14, 2013

I'm trying to find a way to use a macro to extract data from a specific column from Sheet1 based on the columns header/title and copied into Sheet2 into the respective column with matching header/title.

For instance, in Sheet1:

Chicken
Cow
Donkey
Pig

[Code]....

So the above table would be the result i'm aiming for.

NOTE, its not different workbooks. I'm looking for sheet to sheet macro.

I've attached a file as well if someone wants to have a go at it. There are no codes in it.

View 3 Replies View Related

Convert Column B As Multiple Column Titles And Move Data In Column C Into New Columns?

Jun 30, 2014

I have a excelsheet that looks like this:

Column A | Column B | Column C
Los Angeles | Fire Dept | 3
Los Angeles | Health Services | 12
New York | Fire Dept | 8
New York | Health Services | 22
New York | Internal Services | 100
New York | Public Works | 7
Chicago | Health Services | 15
Chicago | Public Works | 56
Chicago | Social Services | 4

And I am trying to make it look like this:

Fire Dept
Health Services
Internal Services
Public Works
Social Services

Los Angeles
3
12

New York
8
22
100
7

Chicago

15

56
4

View 8 Replies View Related

Verify Data In Specific Range Or Move To Next Open Cell Down And Past Value?

May 9, 2013

I have a command button that will run paste a value in a specified cell but I also need it to check for the next open cell and paste the data if the previous cell in a specifid rage is already filled with data. Here is my code I have below. *jumps with Joy* My Range is E6 to E10

VB:
Private Sub CommandButton1_Click()
Dim f As Double
Dim t As Double

[Code].....

View 1 Replies View Related

Set Of Column Data Move To Different Column And Delete Unwanted Column VBA

May 29, 2014

I have set of data Pasted in 4th row, in the top row 44 columns values assigned i want move data from set of data to different column among these 44 columns

Like "Service Order ID" is 1 column in set of data ,it move to second column of top row

Some of column need to delete. (Service Order Type,Service Order Description,Created By,Status,Contact,Expected Delivery Date,

Creation Date,Priority,Net Value,Currency,External Reference,Reference Date)

I want Get output result in same sheet (Actual).

View 3 Replies View Related

Move Data From One Column To Another Based On Column Headers And Row Text

Feb 7, 2014

I am in need of restructuring a spreadsheet of addresses for mailing purposes. (I tried to find something similar answered previously, but nothing seemed to work for me.)

I have attached a small example spreadsheet below, but our spreadsheets can be hundreds or thousands of rows in length.

I need a macro that will look for the "PO Box" addresses under the column headers named "ADDRESS2" and "ADDRESS3".

The PO Box addresses will need to be moved under the column header "ADDRESS1" within the same row.

It will need to overwrite the text that is already under "ADDRESS1" and delete the text from the "ADDRESS2" and "ADDRESS3" columns - UNLESS the text in 'ADDRESS2" is a PO Box AND "ADDRESS1" begins with "c/o".

If the data in "ADDRESS2" or "ADDRESS3" is anything other than a PO Box it will remain the same. As will "ADDRESS 1".

Basically if there is a PO Box it needs to be in the column named "ADDRESS1" and overwrite anything else that was there. The exception will be for PO Boxes that are in c/o someone else, the PO Box will then need to be listed in the column directly after the column that has c/o.

If the c/o exception will be too difficult the code could just highlight those scenarios and we could fix them manually. We usually do not have a lot of them, but enough that we need to be mindful of them.

The different scenarios are listed in my sample spreadsheet.Also, the code will have to use the column header names in row 1 because those headers are not always in the same column.

View 14 Replies View Related

Move Info In One Column Based On Data In Another Column

Aug 28, 2012

I am trying to move a column of numbers based on the information in another column. I've been looking for about a week and find macros that are close but not quite.

In one column it reads Mobile, Home, or is blank. If the number is a Mobile (column R), the area code (column P) needs to move to column S and the phone (column Q) needs to move to column T and the primary phone (column R) needs to move to column U. Home and blank cells remain as they are.

area (P)
phone (Q)
primary phone (R)
col S
col T
col U

[code]....

View 7 Replies View Related

Data Move To One Column

May 3, 2013

I have large information scattered all over worksheet. If I want to move all data in one column "A" how can I do it?

View 2 Replies View Related

Move Data To One Column

Nov 19, 2008

I have data in multiple columns like this:
http://spreadsheets.google.com/ccc?k...rEspkRfQWMOTUg

I'd like to move all data to one single column (like column #1)
Can someone help me out with a VBA macro ?

View 10 Replies View Related

If Column Contains Data Then Insert A Blank Column And Shift Specific Column To The Right

Apr 22, 2009

What I'd like to do is; If column C contains data then insert a blank column and shift column C to the right.

View 4 Replies View Related

Move Data Daily Into New Column

May 21, 2008

I have used the "Import External Data-Web Query" to gather financial data.

This data is updated daily by the web site. The data fills up columns A2 to E 6000.

The data on Column B is of importance and I need it to be stored daily. I need a code that will store todays Column B data in column F, tomorrows Column B data in Column G, dayafter's column B data in Column H and so on..

In short, I need to create a database automatically..

View 14 Replies View Related

Code To Move Data From One Column To Another?

Oct 12, 2011

coding that will select whatever data is entered in say Coulmn D & then copy it to the botom of another list in Column F.

The amount of rows with data in any of the colums may vary.

View 8 Replies View Related

Copy / Move Data From One Column To Another Without Overwriting

Aug 11, 2014

I have a large spreadsheet which I have extracted the data I need, but I am now having a problem tiding it up.

To simplify. I have 2 columns, both containing data formatted as text, each column has some data, but on different rows.

I need to merge the 2 columns without overwriting the data on the second column, with blank data from the first column, and without the column shrinking or growing.

Here is a section of my spreadsheet that needs merging : Excel-1.PNG

I have tried copy > Paste Special > Skip Blanks, but it just copies the column to the other - no merging.

View 1 Replies View Related

Move Row Data To A Sheet If Column Contains Word

Feb 6, 2014

I have a sheet called 'TimeRecorded' which will contain lots of rows of data.

If a row contains 'invoice' in column H, then the data in that row, preferably as far as column H, should be moved to the next blank row in a sheet called 'Archived'.

I would like the macro to move every row that contains 'Invoice' in column H to be moved.

View 1 Replies View Related

Move Column Data To Row Then Delete Those Rows

Jul 23, 2007

We have a client that provided us with a text file that we imported into
Excel. Rather than have the entire record in one row, they have the record
in 4 rows.

What I need a macro or something to do is move award 2 award 3 and award 4 into the same row and after doing this delete the other rows.

Below is an idea how this looks.
1JohnSmithstreetcitystateZIPaward 1
2JohnSmithstreetcitystateZIPaward 2
3JohnSmithstreetcitystateZIPaward 3
4JohnSmithstreetcitystateZIPaward 4
5BillJonesstreet2city2state2ZIP2award 1
6BillJonesstreet2city2state2ZIP2award 2
7BillJonesstreet2city2state2ZIP2award 3
8BillJonesstreet2city2state2ZIP2award 4

What we need for our data to work is:
1JohnSmithstreetcitystateZIPaward 1award 2award 3award 4
2BillJonesstreet2city2state2ZIP2award 1award 2award 3award 4

View 9 Replies View Related

Move Blocks Of Data In 1 Column To Rows

Nov 15, 2006

Moving Data And Deleting Blank Rows. I am a complete newbie to excel VBA and require assistance (if at all possible). I have data in the following format in an excel sheet (I have a lot more rows but give an example for two rows)... in 1 column but I wish to separate it (i.e. move data along onto the first row in other columns) and delete blank rows.

For Example:

Col1
AAAA
BBBB
CCCC
DDDD
EEEE
AAAA
BBBB
CCCC
DDDD...............................

View 9 Replies View Related

Move Text Data To Next Empty Row In Column

Mar 15, 2007

I am importing a 20 character text string (from a barcode scanner) to H2. I need to send that data to the next unused row in Column A (after insuring that no matching text currently exists in Column A-no action taken if matching data is found). I can provide a copy of the sheet, along with a description of the project.

View 2 Replies View Related

Move Data Based On Criteria In Column

May 2, 2007

Here is the situation:

There is a spreadsheet that I use that has multiple plans in one column for various members. You can see the plan for Robert James and Amanda James is plan 5. If all this information was in column A how would you move the plan type say column C for each member?

For example
Column A
Customer Name
Robert James
Amanda James
Plan 5
Nikki Martinez
James Gross
Plan 6

View 4 Replies View Related

Move Data From One Column To Multiple Columns

Jan 12, 2008

I am trying to move information that is pulled from a database to look cleaner and easier to read. All of the information exports out into column A only. The attachment is a brief example of what it looks like, and what I’m trying to get it to look like.

I want to move the data in col A to 5 columns C through G in groups of 16 rows. Once the last column is filled with a group of 16, it needs to fill below the first group of 16 in column B onward to column F. It should repeat this process until there is no more data in A. The attachment shows it much better than i can explain it.

I have some basic experience with formulas and macros, but I haven’t had any luck trying to manipulate any of them to give me the information the way I have shown. I would prefer to not have to manually type or cut and past the information in if possible.

View 6 Replies View Related

Find Specific Data In A Cell And Move It To Another Cell

Dec 12, 2012

I want to extract the following details into another collumn (bold ) from data in column B1 into C1. The information i want begins with 3 digits with a '/' then other digits follow.

M / AS308 - :308/65588 POUN
S33 / 33 - :133/01504 TR
NI101 - :101/915635 T
N101 - :101/915635

View 4 Replies View Related

Excel 2010 :: Move Part Columns Of Data From 6 Columns To Form 1 Large Column In Column A?

Jan 31, 2013

I have a large spreadsheet converted from pdf whose data still appears in A4 reading format.

I need to move part columns of data from 6 columns to form 1 large column in column A.

For example, move range B8 to B76 beneath range A8 to A76 and range C8 to C76 beneath that etc, page by page working through all 270 pages !

Also need to delete unnecessary 'page headers' throughout as in rows 2-6

View 2 Replies View Related

Excel 2003 :: Find Data And Move It To Column A?

Dec 30, 2011

I have a worksheet with data in it. The data could be in any column or row. I am looking for data which contains the numbers 01. If I find such data, I want to move all the data in that particular cell it to column A.

My code(which is not working) is below. I'm using Excel 2003.

Code:
Sub delete_oldads()
'the code to find 01
Dim cel As Range

[Code].....

View 2 Replies View Related

How To Move Data From Back Column To Front In Excel

Mar 20, 2014

How to move the data from the back column to the front as below

A
B
C

2
3

1

3

1

2

to

A
B
C

2
3

1
3

1
2

View 4 Replies View Related

Move Data From Vertical Column To Line Up Horizontally

May 20, 2008

How do I move data that is in a vertical column to line up horizontally (in separate columns, but same row)? For example, take an address:

Name
Address
City/St
Zip

How do I get it to go from that format to this format?

Name Address City/St Zip

View 9 Replies View Related

Move Data In 1 Column To 4 Different Columns Keeping Same Order

Sep 22, 2008

I have a table with one column of data. The data in this column repeats with 4 relevant pieces of information that I want to put in 4 different columns (fields) in a different spread sheet (or the same would work better and I would just delete the first column when done) keeping the same order the data is now in.
The data currently repeats in a regular pattern (i.e. 123412341234 with no other data in between). I would like to do this with a macro. Could someone help write a macro that will do this

View 9 Replies View Related







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