merging two songs
merging two songs
Is there an easier way to merge the separate SongSelect files for the German version of a song and the English version of a song than copying and pasting each line one at a time?
This may be late but you could speed it up by doing the following
edit the english version and make sure each line ends with a carridge rturn.
copy all the lines from the file
open an spreadsheet
paste the lines into the spreadsheet. This should cause each line to become a row in one column of the spreadsheet
do the same for the Greman version but put them in a new spread sheet.
next add a new column as the first column and paste a incrimental set of numbers in so line one is 1, line two is 2 etc. do this to both spreadsheets.
so you will have something line
1 english line 1
2 english line 2
3 english line 3
and the other spreadsheet will be
1 german line 1
2 german line 2
3 german line 3
Next copy the german spreadsheet into the english one so you will have
1 english line 1
2 english line 2
3 english line 3
1 german line 1
2 german line 2
3 german line 3
Now sort the spread sheet on column A and you will have
1 english line 1
1 german line 1
2 english line 2
2 german line 2
3 english line 3
3 german line 3
now you can copy column b and paste it into a text document and you will ahve your english line and then a german line.
edit the english version and make sure each line ends with a carridge rturn.
copy all the lines from the file
open an spreadsheet
paste the lines into the spreadsheet. This should cause each line to become a row in one column of the spreadsheet
do the same for the Greman version but put them in a new spread sheet.
next add a new column as the first column and paste a incrimental set of numbers in so line one is 1, line two is 2 etc. do this to both spreadsheets.
so you will have something line
1 english line 1
2 english line 2
3 english line 3
and the other spreadsheet will be
1 german line 1
2 german line 2
3 german line 3
Next copy the german spreadsheet into the english one so you will have
1 english line 1
2 english line 2
3 english line 3
1 german line 1
2 german line 2
3 german line 3
Now sort the spread sheet on column A and you will have
1 english line 1
1 german line 1
2 english line 2
2 german line 2
3 english line 3
3 german line 3
now you can copy column b and paste it into a text document and you will ahve your english line and then a german line.