Export a list test cases to an Excel file sorted by 'Name' as displayed on the GUI?

Apologies I missed out that step thinking a Sort in Excel would be the way to go, but I can see that has its own challenges.  I can't see a way to specify the sort order of an export, and the command being sent to the exporter doesn't seem to contain any logic that you could control.  I think we're stuck with the way the data is presented, but you could try SmartBear for a definitive answer: SmartBear Support

 

Alternatively you can workaround the issue in Excel.  Here's one way of achieving that:

Column A = Manually fill the original sort order of rows from 1 to n.  This will be used to keep related rows together

Column B = Add this formula to each row to get the relevant Name value:  =IF(ISBLANK(E2),INDEX(E:E,MAX(INDEX((E$1:E1<>"")*(ROW(E$1:E1)),,))),E2)

Column C = Copy & Paste Special Values the Name from column B

Then use Custom Sort by Column C, then A, to sort all data in test case order

 

	A	B	C	D	E
1	OrigOrder	fxGetName	NewOrder	Key	Name
2	1	Test B	Test B	TEST-T1165	Test B
3	2	Test A	Test A	TEST-T1167	Test A
4	3	Test A	Test A
5	4	Test A	Test A
6	5	Test A	Test A
7	6	Test A	Test A
8	7	Test E	Test E	TEST-T1168	Test E
9	8	Test F	Test F	TEST-T1390	Test F
10	9	Test F	Test F
11	10	Test F	Test F
12	11	Test F	Test F
13	12	Test F	Test F
14	13	Test D	Test D	TEST-T1166	Test D
15	14	Test D	Test D