Re : Excel Sorting a 2-Dimensional Array

1. Enter an Excel worksheet.

2. Enter into the range A1 : C1 = A, C, E.
3. Enter into the range A2 : C2 = B, U, T.
4. Enter into the range A3 : C3 = C, O, P.
5. Enter into the range A4 : C4 = D, I, G.
6. Enter into the range A5 : C5 = E, L, F.

7. Enter a formula into every cell of E1:G5 such that the 2-dimensional
array of A1:C5 would be sorted (alphabetically in the horizontal order,
row-by-row) and displayed thereof. Please show the formulae.

8. Also, sort the 2-dimensional array by showing the unique items only.

9. Please share your comment. Regards.