Combining Two Columns Into One

Feb 27, 2009

Trying to combine Column A (First Name) with Column B (Last Name) Probably very simple.!

View 2 Replies


ADVERTISEMENT

Combining Columns

Aug 28, 2008

I have monthly reports that come to us from a Data Warehouse. They vary in size(row length). The problem is that the information in one column actually belongs in the next column (i.e. C to D). As this information in Column C is just an "offset" from Column D there is no issue with overwriting any data in column D. Manually, I could copy the columm and Paste Special, Skip Blanks, to column D.

I've been trying to do this in code as some reports can be fairly lengthy: As there are some blank rows, I've inserted this FinalRow procedure, to provide the size of each report:

FinalRow = ActiveSheet.UsedRange.Rows.Count + _
ActiveSheet.UsedRange.Rows(1).Row - 1

However, in trying to use the FinalRow value in a "Copy the contents from Column C....Cells(20,3 to FinalRow, 3) and then PasteSpecial to Column D (Operation:=xlNone, SkipBlanks:=True) has not been productive. It keeps producing a number of Errors, in every way that I have tried to make this work.

View 9 Replies View Related

Combining Data From Two Columns

Aug 2, 2006

If I have two columns which are lists of names, how do I make a new column which merges the names from each column into one list, and will refresh when new data is added to the two originals.

View 14 Replies View Related

Combining/merging Columns

Mar 18, 2009

ive got columns of dates that i want to aggregate up into a single column of distinct dates. the dates columns are of varying length, some with gaps in the middle of the column, and some columns are blank. dates in teh columns may duplicate, but i only want distinct dates copied in the single column.

i cant do this by hand because there are dates in around 200 columns so i need a macro or way to do this quickly. ive attached a picture to explain the problem.

View 5 Replies View Related

Combining Columns With Formulas

Apr 6, 2012

I'm working on a project that spans three sheets. A2:A151 of Sheet 1 and 2 is a list of names. The names may repeat and they probably won't fill all 150 rows. What I'd like to do with formulas is combine Sheet 1 and 2 into a single list in Column A of Sheet 3 without repeating names or showing blanks. I'm fine with multiple formulas and hiding columns, whatever needs to be done to make it work. Is this possible?

View 2 Replies View Related

Combining Two Columns To 1 Column

Dec 12, 2007

see the picture below to get an idea of what i want to do.

http://aycu15.webshots.com/image/362...0389296_rs.jpg

View 9 Replies View Related

Combining IF With LEFT To Hide Columns VBA

Oct 28, 2009

I'm trying to write some code to Hide columns if the first 3 characters of cells in a range equal the contents of another (formula equivalent would be something like this =IF((LEFT(A2,3))=A1,"HIDE COLUMN", "SHOW COLUMN"). I have gotten this far but cant get it to work;-

Private Sub Worksheet_Change(ByVal Target As Range)

Dim r As Range, cell As Range

On Error GoTo ErrHandler
Set r = Me.Range("B7:CG7")

Application.ScreenUpdating = False
Application.EnableEvents = False

Row = 1
col = 1

For Each cell In r
If cell.Value = "" And Left(cell.Value, 3) = cell(Row, col).Value Then
cell.EntireColumn.Hidden = True
Else
cell.EntireColumn.Hidden = False

End If

Next
ErrHandler:
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub

View 9 Replies View Related

Combining Columns To Create New Rows Not Concatenation

May 22, 2014

RCA Page for forum.xlsx

I'm trying to get entries from one table to appear in another. The first table is like this:

DateDate
Customer Column1
Description Column1
Customer Column2
Customer Description2
Created By

The table I want to put the data into looks like this:
Date
Customer
Description
Created By

View 2 Replies View Related

Date Formatting - Combining Contents Of Two Columns

Mar 18, 2013

Date formatting. I have two columns first column is for the date (3/6/2013) and the second column is for the time (12:37:16 AM). I would like to combine the content of both columns to be like (2/11/2013 12:35:00 AM) .

I am using concatenate but I don't have any luck. How to combine the content of my two columns.

View 4 Replies View Related

Combining Like Items Across Multiple Columns And Rows

Mar 3, 2014

[URL]...I was trying to use this thread's solution macro on my sheet that is only consolidating columns A, B, and C with a couple thousand lines and I've had it running for over an hour now. There hasn't been any errors but is there any particular reason that might be causing it to take longer than it should aside from having to go through a few thousand rows?

Basically, I only want 1 Version of data in Column B and any other rows that has a match in column B, i want to consolidate unique data from Columns A and C.

A B C
AB 123 AAC
BA 131 AAC
AB 222 CAA

Res:
A B C
AB 123, 222 AAC, CAA
BA 131 AAC

View 2 Replies View Related

Combining Hide Columns With Autofilter Rows

Dec 21, 2008

I have a spreadsheet in Excel 7 for a lifelong cashflow model. The main worksheet is called 'Projection' with ages in rows & income (from a variety of sources) and expenditure (of various kinds) in columns fed with data from the Input sheet.

On the 'Input' sheet I have a button called Format Graphs which controls the following macro:

View 6 Replies View Related

Combining Like Items Across Multiple Columns/Rows?

Jun 9, 2009

This isn't absolutely necessary, but being able to do this easily would cut down on a lot of tedious jobs for me. Let's say I have a set of data like this (I tried to space it out as best I could to give the idea):

View 3 Replies View Related

Duplicate Names, Combining Data Across Columns

Sep 28, 2009

I am waaaaay in over my head here. I've not done any scripting/macro/vb/whatnot work in Excel, but I'm staring down a potential all-night project manually merging data.

Here's what I have:

View 6 Replies View Related

Handling Duplicate Zips - Combining Non-numeric Columns Into One Column And One Row

Jun 27, 2012

Is there a function in Excel that allows you to combine non-numeric columns as a list?

For example, 91401 is a zip shared by three cities: Van Nuys, Sherman Oaks and Valley Glen.

The data is in a workbook as three rows (each with 91401 as the first column, and cities listed individually:

91401 Van Nuys
91401 Sherman Oaks
91401 Valley Glen

I am eventually wanting to do a v-lookup with the zip, but the duplication is causing problems. I want the associated cities listed, but only want one row. The cities could be listed, separated by commas (preferably), like below:

91401 Van Nuys, Sherman Oaks, Valley Glen

The list of zips I have is several thousand long, so it's not practical for me to do it manually. Is there a "pivot table" of text that I could use?

View 5 Replies View Related

Combining Unique Data Into One Row With Columns While Merging / Deleting Duplicate Information

Jun 13, 2014

I have data in excel that has some information the same with a unique field. See below:

Last Name
First Name
ID
Date
Address
Apt #
Acct #
Code 1

[code]...

I want it to consolidate all of the like information but add on the codes in separate columns like this:

Last Name
First Name
ID
Date
Address
Apt #
Acct #
Code 1
Code 2
Code 3
Code 4

[code]...

Also, sometimes the same code is used multiple times but i want any duplicate codes to show as separate codes.

View 5 Replies View Related

Combining IF, AND, OR.....

Jan 7, 2009

I have some code where I use and statements, as follows:

View 4 Replies View Related

Combining IF And IS

Jan 14, 2007

I want to see if a goal has been met and get a "Yes" or "No" so I wrote
=If(A1>=A2),"Yes","No"

But on months not worked where goal and production both equal 0 then I am getting a return of Yes. How can I say is A1 >= to A2, but if both are 0 return N/A?

View 12 Replies View Related

Combining AND And OR

Apr 20, 2009

I am having problems combining AND and OR into a single statement. To start I have a statement =IF(AND(B978="P",R978=0,S978=0),"processed",""). If B=P and R=blank and S=blank then display PROCEED else make blank.

What I want to do is check if S is blank or "N" but when I try to add an OR I get error messages regarding missings )'s =IF(AND(B978="P",R978=0,OR(S978=0,S978="N"),"processed","").

View 3 Replies View Related

Combining Two VBA Together

Oct 11, 2012

I have two vba the first one records the date & time of a cell change in column a and places this in column b

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("a:a")) Is Nothing Then
Target.Offset(0, 1) = Date & " " & Time
End If
End Sub

The second one is a function to get the User logged in to windows.

Function UNameWindows() As String
UNameWindows = Environ("USERNAME")
End Function

What I really could do with is a way of incorporating the user name in the first function so it records date, time and user?

View 3 Replies View Related

Combining First & Last Name

Sep 20, 2006

I have two seperate columns, First Name (Column B) and Last Name (Column C). Is there a way a macro can combine the two into one cell Last Name, First Name.

View 3 Replies View Related

UDF - Combining VLookups

Dec 17, 2012

I am trying to write a UDF function where I lookup if a value is on a range on different sheet. I would like to be able to write what I want the result to be in the function. I also hard coded that the function need 3 range and 3 results, but I know it is possible the make the number of component vary depending on what the user writes. I would like my function to do that.

Here is what I have written so far :

VB:
Function find_para2(var As String, rng As Range, result1 As String, rng2 As Range, result2 As String, rng3 As Range, result3 As String)
If WorksheetFunction.IsNA(WorksheetFunction.VLookup(var, rng.Address, 1, False)) = False Then
find_para = find_para & result1 & ", "

[Code] .....

View 6 Replies View Related

Combining If And Lookup

Jan 31, 2009

I need to find a formula to show the time allowed for each person, now they recomend combining 'if' with 'lookup'. now I may be having a blonde moment but I have tried to figure it out for a while now and i am stuck.

View 14 Replies View Related

Combining Several Rows In One

Jan 16, 2014

I have a big amount of data and want to consolidate it.

I have identical text in Columns 1,3 and 4, but the text in Column 2 is different for all.

How do I make 1 row instead of 3 with Column 2 consolidated?

See the attachment : Excel_list.xlsx‎

View 2 Replies View Related

Combining Records Together

Oct 25, 2008

I have a problem in excel that is very urgent to resolve. I have a table that contains duplicate records e.g two people living at same address. I want to merge those records whose address field value is same. Find attached an excel sheet that contains the exact data and the exact output that I want. I know it requires VBA coding.

View 4 Replies View Related

Combining Code..?

Jun 11, 2009

I have two different bits of code as follows:

View 3 Replies View Related

Combining =REPT And =INT

Oct 29, 2008

ok - I have numbers that need to be converted to 12-digit numbers with leading zeros if they are less than twelve digits. for example, 1234567 would turn into 000001234567 to have 12 digits. to do this, i use:

=rept(0,12-LEN(A1))&A1

additionally, i need to strip off the last three digits and replace them with three zeros. my example would now become 000001234000. assuming the result of my first formula (above) is in cell B1, i would use:

=INT(B1/1000)&"000"

Is there a way to combine these two functions into one formula to make this conversion process more painless? Or is there another formula/function I can use that I haven't thought of or do not know?

View 9 Replies View Related

Combining IF Statements With Max Value?

Nov 26, 2011

I'm having a mental block here. I need the below statement to have a max value of (B14*B4) in the instance where

(B17-B19)*0.7 exceeds (B14*B4),
IF(B17-B19

View 2 Replies View Related

Combining 2 Macros Into 1

Mar 25, 2013

I got 2 macros that I want to run in one go. So to explain:

Here is the data of Sheet1 before the macro is run:

A
B
C
D
E

[Code]....

Keep in mind, when Macro2 is run it puts the data on Column W then X then Y etc as soon as the Column reaches 20 it moves on to the next one.

So my question is:

Is there anyway to combine both macros to just run it once instead of running it individually?

View 4 Replies View Related

Combining 2 Codes Into 1

Jun 9, 2013

Just starting to learn VBA. I have the 2 following codes.Can they be combined into 1 code.I have 2 buttons one say hide rows and the other button says unhide rows....can 1 button be used and when the rows are visible the button says hide rows and when the rows are hidden the button says unhide rows

Sub hiderows()
ThisWorkbook.Sheets("sheet1").Rows("3:12").Hidden = True
End Sub
Sub unhiderows()
ThisWorkbook.Sheets("sheet1").Rows("3:12").Hidden = False
End Sub

View 6 Replies View Related

Combining Two Subs Into One

May 20, 2014

I have two subs which I've been trying to combine into one. Essentially all that is changing is the slicer name and range value.

Here's what I have:

Code:
Private Sub Workbook_SheetPivotTableChangeSync(ByVal Sh As Object, ByVal Target As PivotTable)
Dim cache As Excel.SlicerCache
Set cache = ActiveWorkbook.SlicerCaches("Slicer_Project_Type3")
Dim sItem As Excel.SlicerItem
Dim myString As String
For Each sItem In cache.SlicerItems
If sItem.Selected = True Then
myString = myString & "," & sItem.Name

[code].....

But it's erroring out on me.

View 4 Replies View Related







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