merge

I have a query with financial information (initially16,577 rows) including account name that I'm wanting to merge with a "mapping" query using account name as the common field so that the department from the mapping query is added as a column to my financial data query. When doing a left outer...

Hello I want to select columns in the worksheet and then merge them in PQ. The first part is done. The second part drives me crazy. I searched the web and the best I could find was this: Stackoverflow.com But it errors with: Expression.Error: Das Feld "NAME" des Datensatzes wurde nicht...

Hi everyone, I am a student who's new to Excel VBA and need some help with my code I have a column of values in range L4:L53: 4 2 2 2 2 3 5 .... and so on What I wish to do is merge the cells starting from X4 according to the values in column L E.g. The value in L4 is 4, cells X4:X7 should...

Hello there! I'm an enthusiastic if incredibly amateur Excel user- I usually just use google to figure things out but I'm hitting walls with this issue, so thank you in advance for any support or help you can offer! I'm trying to build a feature into an Excel sheet, so that if you click on a...

I need to determine whether any people have downloaded any applications. But the database that spits out whether a person has done so can only generate lists for one application at a time. So, I have one spreadsheet showing that Bob downloaded Messenger, and another showing that Bob downloaded...

As long as there are matching fields in the source tables, we can join the associated queries (one-to-one, one-to-many, etc.) by using the Merge feature. We are going to use the following sample source tables to demonstrate parent & child merging. These tables have a parent-child relationship...

BCDE1Before After 2Sunday Sunday 3Sunday 4Sunday 5Sunday 6MondayMonday7Monday8Monday9FridayFriday10Friday11 Hello if i want to merge duplicate data, from before to after is it possible with VBA? Thanks 🙏

I'm trying to build a simplemacro in VBA for Excel that would SUM [merge] all the rows that have the same name (value in the first columns) and save as each sheet to CSV file. So for example : sheet1 Apple 20 Banana 50 Banana 10 Apple 80 Sheet2 Orange 10 Melon 15 Orange 25...

I have five (5) different files that have .csv files in them. The five folders of information have five different columnar layouts. Is there a tool/trick/workaround in Power Query or Power BI where I can pull the different columns into one worksheet/table that has all the columns that I would...

Good afternoon all. Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in. As you can see below - A, B and C all share the same data and i need them merged into...

Hello! I need help getting VBA to Merge PDF's based on the path. I've attached a photo. Column A, B, C are file paths as they currently exist. I need VBA to grab and merge all of these columns files and use the Output location in column D as the reference for the new path name and where it...

HI Sorry I'm not familiar with VBA but I need this for my project I need to create VBA button with a code to insert a row under a random selected cell "let's say D" and then merge each of the cellS before it ",C,B,A" with it the new cell inserted under it; for example C2 with C3, B2 with B3...

Was trying to add a Z-score column and needed to calculate mean and median but I can't for certain columns with a large number of null values. Both columns are in the same merged query data source and are both decimal types. I can calculate statistics for one and not the other.

Hello. I desperately need some help with a csv file I need to create to upload products onto shopify. The aim of the game is to sort through the 22 000 lines of data, in order to create a new list which contains maybe 10 000 products with TAGS. This part I've done. (The other 12 000 lines are...

Hello I'm looking for something to automatically merge text of the text in a cell. This can either be immediately or by using VBA and running a macro to do all of them at once. Example for data merge data football, and I'm looking to merge by using VBA to data volly, basketball, and tenis...

I have to table that I have to substract value from base on a row / column label to create another table. I'm basically merging (calculating) two pivot tables N4 cell value should be: =(B6-B18)*M3 But sometimes pivot table are changing depending on source data. I would like formula in 3rd table...

Hi guys, I am relatively new to Excel and this is my first post here so please excuse any errors or stupidity on my part. I currently have two problems. Firstly, I need to merge two columns that contain numbers. The problem is that when I do this it is deleting the zeros in the middle. I have...

I am intending to merge every cells between the two objects "FirstCell" and "SecondCell". Still a relatively new user to vba, hence not really sure what went wrong. I have also declared "EmptyRow" in a previous function. Thank you!!!

Hello again you wonderful people, I have hit another road block from the limit of my skills. i have some data that is download from a bespoke inspection system and unfortunately because of the way that multiple faults can be raised against the same piece of equipment the downloaded data...

just thinking... although some might say that merge cells is the mortal enemy of macro :) but just the same I would like to throw this not so important question or not how or can we count rows of a certain column until merge value changes? say with the given table Bird row count would be 5...