How to apply Transpose paste between 2 different excels?

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

it means I need to match the color and size and then write the qty in
hope anyone can advise any ideas to fix it up ,tks.

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? :slight_smile: