Sort alphabetically a formula result

@KyonDW

Welcome to this excel forum.

Select C2:E8 (bleu cells).

data => sort => sort on colum c

After that you get the result in the green cells.

See the attached file.

Using Power Query/Get & Transform (found on the Data Tab), here is the Mcode, the result and your workbook for analyis.

Please Login or Register  to view this content.

Excel 2016 (Windows) 32 bit

	A	B
1	Product Name	Amount of Product
2	Ayam /kg	4
3	Babat /kg	2
4	Beras lumbung desa	1
5	Bimoli 5L	2
6	Daging sapi /kg	6
7	Emping biasa /kg	3
8	Emping matang manis /kg	1
9	Paket Anak 3	1
10	Paket buah	1
11	Suuk putih /bungkus	2
12	sasa 100gr	2

Sheet: Sheet2

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps

M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced