i have tried using various Rpa.excel files and rpa.tables keywords but unable to achieve it.
Would be interesting to see some examples. One option you can try is
1.Create List of wanted column names in order
2.Create target table
3.Loop over column names
5.Get current column from source table
6.Add column data to target table
7.Save to excel
was able to achieve it using dictionary. Will try this approach as well.
Thanks for the response.