How do I sort by type mark before exporting to excel

I’m trying to export the data in the attached graph for windows to excel but I can’t figure out how to sort my list by the Type Mark, it’s probably something simple but I can’t see it or find it.

1 Like

@JoziB

Ok, so your first code block is my list transpose and the keys code block is my type param then?

I’ve just shut down to catch some sleep, will try it tomorrow and let you know if I get it.

1 Like

@salvatoredragotta - Just did a quick test and that seems to do the job! Thank you!

I think I half got it yesterday, I couldn’t figure out what key was and at which point to link it in my graph. I’ll know for future reference!

1 Like

Just hit a snag with this, because some of the values in the list are one digit it sorts the double digit numbers first, something like this 10, 11, 12, 22, 23, 1, 2, 3, 4, etc

Any way of getting around this easily?

@JoziB Please start a new topic