convert page of text into a Membar file

[learning_portuguese]

Hi guys,

first post and unfortunately am a complete ammateur when it comes to excel, so I was hoping someone could help me.

I'm trying to create a valid Membar text file to load into my software, but am really struggling.

If you have no idea what I'm going on about, Membar is a piece of software that you use to learn a language. You create a text file with word pairs (e.g. English : Portuguese) and then once you load the file into the software, it loops the word pairs at the top of your screen. (http://www.membar.co.uk/en/)

Anyway, I need to create a text file in the format of:

English : Portuguese
English : Portuguese
English : Portuguese
English : Portuguese

etc.

Now I've found a site that lists 100 common portuguese verbs (https://quizlet.com/64428080/100-mos...s-flash-cards/) but when I highlight the text and stick it into excel, I get this:

arrive arrived
chegar

ask asked
pedir, perguntar

be was / were
ser, estar



what I'm really trying to do is take the text from every third row, starting with 1 (e.g. 1,4,7,10,13) and place it into column B

I then want to take every text from every third row, starting with 2 (e.g. 2,5,8,11,14) and place it into column C

once I've done that, I just need to put a colon between columns B and C, which I think is something like =B1&":"&C1

then copy down, so I eventually am left with a column of text that would read:


arrive arrived : chegar
ask asked : pedir, perguntar
be was / were : ser, estar

I can then copy this into notepad and save, and I will have a valid Membar file!

any help would be greatly appreciated!

thanks

[newdoverman]

This should do what you want.
Enter this in B1 and fill down:

Please Login or Register  to view this content.

Enter this in C1 and fill down:

Please Login or Register  to view this content.

Enter in D1 and fill down:

Please Login or Register  to view this content.

Result

	A	B	C	D
1	1	1	2	1 : 2
2	2	4	5	4 : 5
3	3	7	8	7 : 8
4	4	10	11	10 : 11
5	5	13	14	13 : 14
6	6	16	17	16 : 17
7	7	19	20	19 : 20
8	8
9	9
10	10
11	11
12	12
13	13
14	14
15	15
16	16
17	17
18	18
19	19
20	20

[learning_portuguese]

that worked great! thanks!