Sorting Data Grid - Row, then Column (Alphabetically)

[Blackmarxz]

Hello

I have a grid of data that I'm looking to do a two-step sorting process on

1 Sort each row alphabetically

2 Sort each column Alphabetically


For illustration - original data grid (reads horizontally) could look like below:

1	2	3	4	5	6
Orange	Apple	Pear	Blueberry
Apple	Kiwifruit
Lime	Banana	Blackberry
Kiwifruit	Orange	Pear	Lime	Melon	Starfruit
Durian	Jackfruit	Watermelon	Pear	Apple

<tbody>
</tbody>

After being sorted should look like :

1	2	3	4	5	6
Apple	Blueberry	Orange	Pear
Apple	Durian	Jackfruit	Pear	Watermelon
Apple	Kiwifruit
Banana	Blackberry	Lime
Kiwifruit	Lime	Melon	Orange	Pear	Starfruit

<tbody>
</tbody>

Firstly each row was sorted horizontally. Then each column vertically - keeping each row's data intact

Rows will have different number of data points

Would prefer to do it via formulas if possible.

Numbers at top are column headers

Data set could grow to a couple thousand rows. Columns perhaps up to 30

If you can find a way to automate this it would be much appreciated. Can do it manually - but is fiddly and painful with alot of data.

Cheers