I have catched the data and created a datatable like the original one as below:
but the system I need to input just recognize the format as below
Hi @xiepanfeng
One way to transpose paste is to use the hotkeys. After you select the range you want to copy within Excel Application Scope and you copy it, you would select the first cell where it needs to be copied to. Then with Alt+Ctrl+v you can bring up the Paste menu, where typing e + enter will select transpose. See some example below that you can hopefully adapt to your needs. Does it help in any part of your problem? 
