merge

I have a list of movies that have won or been nominated for one or more awards in various years. I want all award information for one title to appear on one line. Is there a way to do that? Each award has three columns of information: award name, whether the film was nominated or won, and year...

Hi Experts, Project: I am working on Power BI project where I am fetching data from many JIRA projects. The only problem here is one field which is not used in a harmonized way for across all JIRA projects and i.e. Release Information. For all JIRA projects in my report, I derived that...

Dear Pros, Please how can I use formula to create COLUMN C from A and B?

I'm trying to create a macro that will create a new workbook and then copy all sheet(1)'s from all other open workbooks to it except for the workbook where I have all my macros stored. So far, I'm able to create the new workbook and save over it if needed (and it will be). But it's not copying...

Hi all, I am trying to build a tool in excel that can simulate and give an overview of packing plans, but i am having trouble getting a "timeline" to work. The sheets with the timeline are imported based on choice and will change in how many are imported. It needs to be VBA, the persons who...

Good evening everyone, I had a question ... btw, excuse my bad english: I have a couple of tables, CONTRIBUTION and BILLING, which have an "ID" field with which I relate them (the relationship between the tables is * (CONTRIBUTION) -> 1 (BILLING)), as well as a CONSUMPTION (numeric) field , a...

Hi all! Im having some issues with my code below. It works fine on majority of rows, but towards the end, it's having some issues. What my code does is this: - if values of cells (i,j) and cells (i+r,j), basically 1 cell and the cell below it are the same, then they merge and other columns...

Hi all i have 5 files for 5 regions each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis ) i merged it by my PQ File file then i use PQ also to Merge it all in one file that is mean i use PQ 5 times for 5 files then i use it again to merge it all in one file can...

<tbody> Email Data Ste@google.com 1 ste@google.com 2 Bob@google.com A Bob@google.com B </tbody> Hi guys is there a way that I can mail merge 1 email with several rows of data, instead on several emails with 1 row of data? desired result - Ste recieves 1 email which states...

I use excel spreadsheets (xls, DDE) as the database for my mail merge in word. After the upgrade to Word 2016, the excel open a new file (Book2) automatically when I open the word file. The main problem is that when the new excel file (Book 2) was opened, all the previous entered data was not...

Hi I am new to these concepts. Not requesting for exact answers. You may also help me with useful links for these two. I know Google will help, but trying to seek help from experts here. Also, I have another question here. Not sure if I can merge it here only. How does early binding or late...

hello i need help to find code merge data from 3 sheets in one sheet i have 3 sheets every sheet contains data in table with headers begins from b4: h10 i would code to merge data from theses sheets to sheet4 also when happens every change automatically changes in sheet4 i...

Hi all, So I have a few tabs with changing names, that sometimes are there and others there aren't. For example. I will always have a "Sheet1" then after that they may not be there, "Sheet1 (2)", "Sheet1 (3)", etc. I need help writing a macro that will copy the data from "Sheet1" into Cell A1...

I am trying to merge 5 columns together where only one column will have a date in (dd-mm-yyy) and the other 4 will be blank. The column that contains the date is random and changes as you go down the spreadsheet. Can anyone shine a light on a formula that KEEPS FORMATTING of the date when the...

Hi, I'm working on a stats project and need some help. I've got my two columns, one for first names and the other for last names, and I'm trying to figure out how to merge them so they read in one cell as the full name and then alphabetize them by last name; if it is possible. I've gone as...

I have to setup a series of mail merged forms for my school to invite guest speakers to our classrooms. For that, I have setup a table called Guest_Speaker_MM. I've already created all the merge fields and tested them using manual mail merge and they worked fine. However, when these files...

Hi all, I want to merge two ranges together. The first range is equal to Sheets("1").Range("B1:AA100") the second range is equal to Sheets("2").Range("B1:AA100") I am familiar with the UNION-function, but I want to merge them differently. Basically, I want to merge them column for column...

Hi All, I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel. so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so...

Hello everyone. Is there a way to tweak the below vba so it only merges 2 sheets from my workbook vs ALL the sheets in the workbook? For instance i need it to merge sheet name "hello" and sheet name "bye" THanks!! Sub merge() Dim wrk As Workbook Dim sht As Worksheet Dim trg As...

Hello, I am working in a mail merge document, and I need the output to look something like this: Vacation: Life Insurance: Disability: etc. However, the issue is that sometimes the fields are blank, and if they're blank it messes up the spacing. I want the document to ignore any blanks...