merge data columns

I am VERY new to Access. I have managed to pull in 2 different Excel spreadsheets and can run a query combining the information need from between the two. However I have a column named the same in both with different sales numbers. So let's just call it Sales. When I query them I get 2...

Hi, I am trying to merge the cells in a column (column B) based on a condition in another column (Column C). In Column C, I have a list that starts at 1 and goes to a maximum of 10. However, it may stop at any number before 10 and restart. For Example: B C 1 2...

I am having trouble moving data from one column (I am using this column as a helper column for data based on another sheet) into a different column on the same sheet, but without bringing along blank cells. This is the situation: <!--StartFragment--> <colgroup><col width="65" span="2"...

Okay, so, I have a problem that has caused a bit of hair-pulling on my side, especially as all I have been able to Google results for is how to concatenate two cells with an ampersand: Basically, I have three columns, A, B and C. These columns will contain variable amounts of data, based on the...

I have 2 excel sheets, both are csv files. I imported one from Outlook with names, emails and telephone no's, the other was from access with names and addresses. I want to merge them. The problem is there are some of the same names in both but not all. I want to be able to match the info of...

I have been tasked with creating a macro for this is a report that is run pretty frequently and it takes some time to put together. I tried recording the macro but it doesn't work out the way I intend for it too. I am not very familiar with VBA but a macro would greatly help with this process...

Hi, I’m new here and I’ve been working on a macro that’s driving me crazy. So I have three worksheets in one workbook (A,B and C). I want to merge data from four columns across worksheets A and B onto worksheet C. However, worksheets A and B do not have my four columns listed in the same order...

Hello there, We are doing a graduation project on an international airport, consist of scheduling flights on check-in counters automatically. long story short, we ended up with an excel sheet like this: Were y-axis are the check-in counters and x-axis is the timeline horizon (cell per...

HI I have two columns Req | Expiry Date yes 11/12/2010 yes 08/06/2012 yes 02/07/2017 how do i merge both columns into one.. not losing any data hence Req Expiry Date yes 11/12/2010 yes 08/06/2017 I am using excel 2007 PLS HELP - ITS FOR WORK!:eeek: