Help with cell data transfer

[Ezguy4u]

Ok so this should be a simple ask. Now there is more data, but I want to reduce the data and make it simple and still get an idea on the solution. So the input is columns A to C and the output is in columns E & F. I am open to formulas, functions or even VBA. Note the numbers being separated and pasted into the next cells. If I have missed something or there are questions let me know. Thank you for you time.

pas 2 a.xlsx
	A	B	C	D	E	F
1	Jungle Peace	Schilified	Jungle Peace (11)		Jungle Peace
2	Schilified	Hey Lil Lady	Schilified (9)		Schilified
3	Aunt Mo	Jungle Peace	Hey Lil Lady (7)		Aunt Mo
4	Wound Up	Clampett	Wound Up (20)		Schilified
5	Clampett	Wound Up	Clampett (8)		Hey Lil Lady
6	Kahuna Magic	Kahuna Magic	Kahuna Magic (3)		Jungle Peace
7					Jungle Peace	11
8					Schilified	9
9					Hey Lil Lady	7
10					Wound Up
11					Clampett
12					Kahuna Magic
13					Clampett
14					Wound Up
15					Kahuna Magic
16					Wound Up	20
17					Clampett	8
18					Kahuna Magic	3
Data

 

[alansidman]

Power Query Solution

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Columns", "Value", Splitter.SplitTextByDelimiter("(", QuoteStyle.Csv), {"Value.1", "Value.2"}),
    #"Replaced Value" = Table.ReplaceValue(#"Split Column by Delimiter",")","",Replacer.ReplaceText,{"Value.2"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Replaced Value",{"Value.1", "Value.2"})
in
    #"Removed Other Columns"

 

[Ezguy4u]

Power Query Solution. Ok While not one of the methods I mentioned, I will take this opportunity to acquaint myself with Power Query. I like a challenge and getting the above solution to work will only make me a better excel person.

 

[Ezguy4u]

Ok I believe I got the above Power Query Solution to work but it does not look like the output I need. Unless I am missing something, I need the output to look exactly like columns E and F. I have a Power Query book I will continue to read, bur for now I am still without a solution.

PQ Work 4.xlsx
	A	B
1	Value.1	Value.2
2	Jungle Peace
3	Schilified
4	Jungle Peace	11
5	Schilified
6	Hey Lil Lady
7	Schilified	9
8	Aunt Mo
9	Jungle Peace
10	Hey Lil Lady	7
11	Wound Up
12	Clampett
13	Wound Up	20
14	Clampett
15	Wound Up
16	Clampett	8
17	Kahuna Magic
18	Kahuna Magic
19	Kahuna Magic	3
Data Sample

 

[Ezguy4u]

How do I go about reposting this problem? What do I have to do to get people to look at this problem again?