Remain 1 columns and convert 2 column to many Rows

[mohammaduir]

I want to marge the same data from Column A and remain in the same previous Column.
Then every data in Column B converts to one separate Column (Many data in this Column are common), and data of Column C (for every raw) comes to below of new related Column.

It should be noted that the total number of data is very large (more than 100,000 rows)

For example:

Column A (Name)	Column B (box)	Column C (number)
Aaa	box1	2
Aaa	box5	5
Aaa	box6	9
Bbb	box3	8
Bbb	box6	1
Ccc	box1	3
Ccc	box3	5
Ccc	box5	4
Ccc	box10	1

I want it to look like this

Column A (Name)	Column B (box1)	Column C (box3)	Column D (box5)	Column E (box6)	Column F (box10)
Aaa	2		5	9
Bbb		8		1
Ccc	3	5	4		1

thanx a lot.

 

[sandy666]

(Name)	(box)	(number)		(Name)	box1	box5	box6	box3	box10
Aaa	box1	2		Aaa	2	5	9
Aaa	box5	5		Bbb			1	8
Aaa	box6	9		Ccc	3	4		5	1
Bbb	box3	8
Bbb	box6	1
Ccc	box1	3
Ccc	box3	5
Ccc	box5	4
Ccc	box10	1

let
    Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
    Pivot = Table.Pivot(Source, List.Distinct(Source[#"(box)"]), "(box)", "(number)", List.Sum)
in
    Pivot

Download Power Query from Official Microsoft Download Center

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. (Note: The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. Please upgrade...

www.microsoft.com

 

[Fluff]

Cross posted Remain 1 columns and convert 2 column to many Rows
and Remain 1 columns and convert 2 column to many Rows - OzGrid Free Excel/VBA Help Forum

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

If you have asked this question on any other sites please supply links.

 

[alansidman]

Also at: Remain 1 columns and convert 2 column to many Rows [SOLVED]

 

[Fluff]

@mohammaduir
You were asked to provide links to all other sites, not only have you failed to do so, you have now cross posted this at even more sites.
You must supply all relevant links.