[ASK] how to solve column to row sort table by 3 column (A,B,C) ?

Excuse me, I'm a newbie want to ask some question about my problem.
how to solve column to row sort table range by 3 column (A,B,C) like this?

pict.JPG

so, it's sort by column A (name), B (city), and C (item)

I'm using this reference from JBeaucaire (https://sites.google.com/a/madrocket...n-sets-to-rows)
but that's only works with sort by 1 column

I hope, all seniors can help me to solve this problem.
Thank You

Just add filters to row 2

Highlight row 2 then hit the keys on your keyboard (One at a time) in this order
ALT
A
T

You will see small arrows appear in the boxes or headers of your data. Use these to sort by the column(s) of choice -

Seems like the original macro would still work if you prepared your data.

1) Insert a new blank column A
2) In A3, put this formula and copy down: =B3&"-"&C3&"-"D3
This creates a single-cell version of your 3 columns.
3) Copy A3:A1000 and do a PasteSpecial > Values to flatten column A and remove the formulas.
4) Delete columns B:D

5) Now the data is in the correct format, run the macro.

6) When merge is complete, insert two blank columns as B:C
7) Highlight the data in column A and do a TEXT-TO-COLUMNS split on the "-" character, this will split the data back out to 3 columns.