Combining two columns in one(not concut)

[datastudent]

Hi,

Please help me combine two set of data in one column without using pivot.

The first table is the data that I have and the second table is how I want it to be. I would like a formula that would give me the result for both tables please like if I have table2 how do I get table1 and vice versa. Thank you!

Template_v1.xlsm
	A	B	C	D	E	F	G
1	Name	Fixed	Mobile		Name	Service	Cost
2	AAA	123	122		AAA	Fixed	123
3	BBB	234	345		AAA	Mobile	122
4					BBB	Fixed	234
5					BBB	Mobile	345
Sheet7

 

[datastudent]

Ok, how about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Country	Service Plan	Origin type	OUT FIX/OUT MOB
2	AUSTRALIA	Fixed	National	0.0116				Fixed	Mobile
3	AUSTRALIA	Fixed	National	0.0116		AUSTRALIA	National	0.0116	0.0306
4	AUSTRALIA	Fixed	National	0.0116		AUSTRIA	National	0.0082	0.0092
5	AUSTRALIA	Fixed	National	0.0116
6	AUSTRALIA	Mobile	National	0.0306
7	AUSTRALIA	Mobile	National	0.0306
8	AUSTRIA	Fixed	National	0.0082
9	AUSTRIA	Fixed	National	0.0082
10	AUSTRIA	Mobile	National	0.0092
11
Data

Cell Formulas
Range	Formula
F2:I4	F2	=PIVOTBY(CHOOSECOLS(A2:C100,1,3),B2:B100,D2:D100,MAX,0,0,,0,,A2:A100<>"")
Dynamic array formulas.

This works. But what if we remove the origin type column? If we want to have Country, Fixed and Mobile column only.

 

[Fluff]

Like

=PIVOTBY(A2:A100,B2:B100,D2:D100,MAX,0,0,,0,,A2:A100<>"")