From table to table

[Wojciech]

Hi! I have created database table:

	A	B	C
1	Database:
2	111111	1.1__something_1_.,+-/	5
3		1.2__something_1_.,+-/	10
4		1.3__something_1_.,+-/	20
5		1.4__something_1_.,+-/	something_1_.,+-/
6
7	222222	2.1__something_1_.,+-/	data1
8		2.2__something_1_.,+-/	data2
9		2.3__something_1_.,+-/	data3
10
11	333333	3.1__something_1_.,+-/	12
12		3.2__something_1_.,+-/	999
13		3.3__something_1_.,+-/	1
14	XXX	4444	?
15		xyz
16
17

<tbody>
</tbody>

I need a formula, one that gives results as I showed in column G below:

	E	F	G
1	Table created on the basis of the database	I need a formula whose solution is:
2	111111	1.4__something_1_.,+-/	something_1_.,+-/
3		1.3__something_1_.,+-/	20
4	222222	2.2__something_1_.,+-/	data2
5	333333	3.1__something_1_.,+-/	12
6		3.3__something_1_.,+-/	1
7		3.2__something_1_.,+-/	999
8
9	XXX	4444	?
10		xyz

<tbody>
</tbody>

 

[Wojciech]

To simplify the formula solution, the database might look like this:

	A	B	C
1	Database:
2	111111	1.1__something_1_.,+-/	5
3	111111	1.2__something_1_.,+-/	10
4	111111	1.3__something_1_.,+-/	20
5	111111	1.4__something_1_.,+-/	something_1_.,+-/
6
7	222222	2.1__something_1_.,+-/	data1
8	222222	2.2__something_1_.,+-/	data2
9	222222	2.3__something_1_.,+-/	data3
10
11	333333	3.1__something_1_.,+-/	12
12	333333	3.2__something_1_.,+-/	999
13	333333	3.3__something_1_.,+-/	1
14	XXX	4444	?
15	XXX	xyz
16
17

<tbody>
</tbody>

 

[Wojciech]

Thread solved.

Excel Workbook
	A	B	C	D	E	F	G
1	Database:				Table created on the basis of the database		I am looking for a formula whose solution is:
2	111111	1.1.1__something_1_.,+-/	5		111111	1.3.1__something_1_.,+-/	20
3	111111	1.2.1__something_1_.,+-/	10		111111	1.4.1__something_1_.,+-/	something_1_.,+-/
4	111111	1.3.1__something_1_.,+-/	20		222222	2.2.1__something_1_.,+-/	data2
5	111111	1.4.1__something_1_.,+-/	something_1_.,+-/		333333	3.1.1__something_1_.,+-/	12
6	222222	2.1.1__something_1_.,+-/	data1		333333	3.1.1__something_1_.,+-/	12
7	222222	2.2.1__something_1_.,+-/	data2		333333	3.1.1__something_1_.,+-/	12
8	222222	2.3.1__something_1_.,+-/	data3		444444	4444	?
9	333333	3.1.1__something_1_.,+-/	12		444444	xyz	0
10	333333	3.1.2__something_1_.,+-/	999
11	333333	3.1.3__something_1_.,+-/	1
12	444444	4444	?
13	444444	xyz
Arkusz1