Questions tagged [merge]
The merge tag has no usage guidance.
375
questions
0
votes
3
answers
30
views
It is possible to track back how many cells are merged with TEXTJOIN [Excel]?
I am combining multiple values into a cell in Excel using TEXTJOIN
This is the dummy dataset (the actual dataset contains thousands of entries, and each entries contains hundreds of characters so it ...
0
votes
1
answer
42
views
How to condense data irregularly distributed over several rows in an Excel table
Actual Table: Data irregularly distributed over several rows and thus partially empty lines
Date
Text
Date_1
Text_1A
Text_1B
Date_3
Text_3A
Text_3B
Text_3C
Date_6
Text_6A
Text_6B
Date_8
...
- 3
0
votes
1
answer
15
views
Merge 2 columns in Excel and make data permanent
I know how to concatenate 2 columns in Excel, but I want the new column to become merged data NOT dependent on the formula. The reason is I can't copy the results into a new column.
I.e.
|col 1 | ...
- 11
0
votes
0
answers
42
views
Excel - How to combine columns (without concatenating them) from multiple files
I have multiple CSV files, each containing several columns, but only one of interest, column B. It's a column whose header is "Results" and each row in the column contains numeric data.
For ...
- 1
0
votes
0
answers
11
views
Merge Inkscape files without losing the layer information
In Inkscape 1.1.2, how can I merge two Inkscape files without losing the layer information of one of the files? Copy-pasting or importing flattens the inserted image.
Even if I manually, for each ...
- 145
0
votes
0
answers
11
views
In Word, how can I retain merge source (from text file) when I reopen document
I have been doing simple mail merge in Word (latest version) using a CSV text document as data source.
This works, I can assign fields, and do mail merge.
But when I open the word document next time, ...
- 117
0
votes
1
answer
37
views
How can you merge two hard drives of 4TB?
Yes, I know it is not recommended (but it's only temporary) and yes, I know I would lose all my data if something happens.
But, is there any way to merge my two 4TB drives into one ? I tried with the ...
- 336
0
votes
0
answers
95
views
ffmpeg Combine 2 video files into one with two audio tracks (different languages)
I have multiple pairs of video files (.mp4) that are basically the same video but in different languages (original english and synchronised german in my case). I know that with ffmpeg I can take ...
- 1,509
5
votes
2
answers
127
views
How do I save a whole MS Word document to single-paged PDF?
I am working with MS Word and there are quite a few places where I care about the final look of the document. I don't want to split certain parts (for example pasted source code). I also don't want to ...
- 151
-1
votes
1
answer
34
views
Merge two ext4 spaces
I want to merge /dev/nvme0n1p6, which is system linux disk and /dev/nvme0n1p9. I have also Windows system on /dev/nvme0n1p4, so i want to save it
How can i merge /dev/nvme0n1p6 with /dev/nvme0n1p9 ...
0
votes
0
answers
50
views
PowerPoint VBA: Merge 1000 Presentations, preserving formatting
I need to merge many (around 1000) PowerPoint presentations into one. My presentations have different extensions, some are ppt and some are pptx. I need to merge them with VBA Macros preserving source ...
0
votes
0
answers
864
views
How do I fix audio/video sync in ffmpeg
I have a video in 1080p but for some dumb reason, the audio is only stereo. I also have the same video in 480p but the audio is 5.1. I've merged several videos taking the 1080p video from one source ...
- 51
0
votes
1
answer
47
views
merge rows in excel
I have a lot of rows with different values, but in the first column I have the same value. My goal is to merge the different lines into one based on the value of the first column. In the example, only ...
- 23
0
votes
0
answers
80
views
How to merging 2pdf's with pdftk where output file have name one of them
I have many pair's of PDF's to merging with different names. I need to merging pair, without the first page of the second PDF and call the output file the name of the second PDF. First pdf name's ...
- 1
0
votes
0
answers
33
views
How to merge many photos automatically?
How to merge many photos automatically?
I have 2 folders of photos, 200 photos each.
I need to merge (side by side) the 1st photo from the 1st folder with the 1st photo from the 2nd folder.
0
votes
0
answers
95
views
Merge folders via right-click menu
Is there a way to create a button in the right-click menu of Windows Explorer to merge the content of folders? Illustration
Upd: It could be probably done using information from this question, Windows:...
- 1
1
vote
1
answer
59
views
Can Power Query be adjusted to only target one sheet?
I have several thousand excel workbooks. Each excel workbook has three sheets named "site", "survey" and "project info". I want to merge all of the "survey" ...
- 143
1
vote
1
answer
30
views
Safeguarding code against merge conflicts
Assuming git for version control: If a colleague is modifying code (in their own branch) that I am also working on (in my own branch), and I'm aware of the changes they are putting in place, can I ...
- 11
0
votes
0
answers
60
views
How to merge folders that have similar (not the same) names, in a folder keeping as its name the common part of the name of the two folders
I have a list of folders that look like this:
123_S1_R1_001 AND
123_S1_R2_001
456_S25_R1_001 AND
456_S25_R2_001
789_S83_R1_001 AND
789_S83_R2_001
Each of the folder contains a fastq file (eg ...
2
votes
2
answers
401
views
Merge .txt files in Specific Order
I have a set of 300 chapters named Chapter 1.txt, Chapter 2.txt... Chapter 300.txt]
The goal is to try to create a combined .txt file with all of these chapters in order.
Each file is formatted with ...
- 23
0
votes
1
answer
128
views
merge columns in 2 text files properly
I have 2 text files.
The first has data:
LA_3_45 test 1
LA_3_45 test 2
LA_3_45 test 3
..
The Next has Numbers:
1.34
2.53
-0.54
...
I want to combine them column-wise:
LA_3_45 test 1 1.34
LA_3_45 ...
0
votes
2
answers
226
views
Merge Excel rows based on common column values
I have a table similar to the image below. Column A has repeated values, while column B has values corresponding to column A. e.g. a single customer can have multiple orders.
What I would like to do ...
- 141
0
votes
4
answers
82
views
Excel - combining rows of data
I need help with merging multipul rows in excel, I need rows by the same name and date to merge together into one line joining the tasks done into one row (date).
currently I am manually merging ...
0
votes
0
answers
145
views
FFMPEG - Merging .wav files with acrossfade and getting audio crackling
i'm merging two audio files into 1 with a acrossfade filter.
Here is my acrossfade filter config: acrossfade=d=10:o=1:curve1=cbr:curve2=cbr;
The merge is working well, but for some files it results in ...
- 1
0
votes
3
answers
436
views
Batch merging PDF files based on file name
I'm trying to find a program/script that can merge files based on the filename.
Files are in 1 folder (output from PDF24 print to PDF) and names as the following example:
File name layout: YYYY-MM-DD ...
- 11
0
votes
1
answer
76
views
set background colour in tables based on merge field from serial letter
I have set up a word document as a serial letter containing a table referencing data from an excel document.
The table in the word document should change the cells background colour if another field ...
0
votes
1
answer
45
views
Possible to combine two device specific WiFi networks?
Onboard my sailing boat I have at least two devices that creates separate local WiFi's to transfer information to my tablet. Device 1 is a depth sounder that transfers the sonar image and device 2 is ...
- 1
1
vote
1
answer
105
views
Zoom and morph at the same time using ImageMagick
I have two different maps of the same region: one from a distance, the second a close up.
The white retangle in the first image represents the border of the second image.
I want to apply two effects ...
- 161
1
vote
1
answer
42
views
syncing two folders into one, removing deleted files
Given folders named Drive1/Folder1 and /Drive2/Folder2 I want to have a folder /Drive3/folder3 that contains the synced merged contents of both the source folders, but does not contain any files or ...
- 113
1
vote
1
answer
91
views
I concatenated two pictures with the "copy /b" commande, and now I want to get the two images back. How can I do this?
So, like the title say, how can I do this? I noticed that the file size has increased, so the two files are really concatenated, and I deleted the original ones, now how can I unmerge the two pictures?...
- 19
0
votes
2
answers
376
views
Merge filters in a pivot table (Excel)
I have a very simple pivot table that has multiple filters.
Example of source worksheet:
Pivot table source
The pivot table just lists all the Employee names (e.g. Employee A) and provides 5 filters ...
- 3
1
vote
1
answer
34
views
Merging every 4 cells and adding the data for Electricity Bill
I downloaded some data from my electricity bill that is organized in 15 minute increments. There's way too many data points, so I'm looking to find a way to merge down this data to show usage in 1 ...
- 13
0
votes
1
answer
26
views
How to Concatenate multiple columns at once?
I have an excel sheet as follows:
A B D D E
157 158 14644 28495 Https://www.google.com\
110 111 10142 21123 Https://www.youtube.com\
192 193 18538 36658 Https://www.baidu....
0
votes
1
answer
80
views
Is it possible to merge the partition type of EFI System into Linux Filesystem?
The partition of my machine which is mounted at /boot is almost full, thus I cannot update my kernel anymore. Meanwhile there is another partition which is mounted at /boot/efi and it is totally free. ...
- 103
0
votes
1
answer
254
views
Batch: Merge specific parts of mkv files
I have several Folders of MKV files. each folder contains episodes of a series with english Audio track and good quality of video and same episode with Farsi dubbed audio track (and also english) but ...
- 1
0
votes
1
answer
173
views
Merging 1 Column with multiple rows per row label
I have a pivot table that has different columns. First column is Part Numbers, next column is part name.
There are a random number of lines for each Part Number
I copy and paste this into another ...
2
votes
1
answer
105
views
In Office 365 Word, how do I merge several word files into one in order?
I want to merge about 500 word documents into one. Each document is 2 pages long, and their names is a three digit number, and they are in order: document 001 goes before 006, even 003 to 005 do not ...
- 131
0
votes
1
answer
56
views
Merging Videos And Video Player Together
I'm trying to find something to help me merge a video file with its software so the client can only view the data/video from this software without copying the files to his/her computer.
I have seen a ...
- 1
2
votes
1
answer
183
views
How to merge empty partitions to main partition without data loss in main in macOS?
I tried to install Windows in my MacBook Pro (13-inch, Mid 2012) having macOS Mojave. Tried without the bootcamp assistant as directed in the link -
https://fgimian.github.io/blog/2016/03/12/...
- 71
1
vote
0
answers
369
views
MacOS Catalina: Extend APFS Volume
Following is the result of diskutil list command:
I want to extend disk0s2 to take up available space (29GB) since I have 128GB SSD and I have deleted container disk of size 29GB. I tried with disk ...
- 111
1
vote
1
answer
51
views
Sync a Merging in ffmpeg
I was able to merge video and audio but the video is one frame off to the right. I'm trying every way I can see online but there's no way to sync that jump frame. I'm using the following code but I ...
1
vote
1
answer
47
views
In Excel 2007, how do I remove duplicate lines, while merging data
To help you understand the question, here is a sample:
I have this:
Name - Account# - Address - . . .- phone
Mr. A . . 4278 . . . . 123 Main . . . 555-1212
Mr. B . . 7532 . . . . 435 ...
- 11
0
votes
2
answers
2k
views
Why is my partition showing as being in 3 parts?
I have a partition that is split into 3 parts, how can I merge them or just make them adjacent so they merge automatically?
- 3
2
votes
1
answer
385
views
How to merge three mp4 files with same encoding/codex by Avidemux using command line?
Assume that one has three mp4 files with the same encoding/codex, say file1.mp4, file2.mp4, file3.mp4.
How can one merge these files into a single mp4 file, using command line by avidemux?
- 353
0
votes
1
answer
432
views
FFMPEG input 6 x 24 bit mono but output 5.1 16 bit
I would like to create a 5.1 wav file from 6 mono. Those 6 mono files are 24 bit, but FFMPEG output a 16 bit 5.1. So I forced ffmpeg to transcode in 24 Bit with -c:a pcm_s24le as shown above :
'/...
- 15
0
votes
1
answer
1k
views
How do you add blank space in mail merge?
Can anyone tell me how to add blank spaces in mail merge 2007? I'm printing labels for file folders that contain the month and year. The problem I would like to have a blank space between the month &...
0
votes
0
answers
290
views
ffmpeg partially concat meets sample rate issue
I use ffmpeg concat to merge multiple ts files, I use following command
ffmpeg -y -f concat -i filelist.txt -c copy test.mkv
all ts files' path is put in filelist.txt, it runs well, but now my ...
- 83
6
votes
3
answers
368
views
How to merge rows with Excel?
I have a worksheet containing:
ID VALUE1 VALUE2
--------------------------
ABC 8274
DEF 613
GHI 236
ABC 11.13
XYZ 173
GHI ...
- 1,636
1
vote
1
answer
785
views
vsDiffMerge not running as Sourcetree external merge tool
I'm trying to set up vsDiffMerge (from Visual Studio Professional 2017) as my external merge/diff tool for SourceTree. However, when I try to resolve merge conflicts with the external tool, nothing ...
- 111
1
vote
4
answers
15k
views
Merge multiple columns into one
In Excel, I'd like to merge/combine the data of multiple, nonconsecutive columns into one (excluding the headers, preferably on another sheet).
Example: I have a sheet containing rows of names which ...
- 11