Is there a way to pull a collection from excel by row data instead of by column? For Instance the data is entered into excel as shown below:
Name John Jack Jeff
Age 23 22 24
Sex M M M
City NYC STL SEA
In this scenario I would want Name, Age, Sex, and City to be the Fields in the collection
I realize I could manipulate the excel file and organize it into columns, but I'm hoping to find a way for blue prism to pull the data into a collection as is.
------------------------------
Josh Harris
Solution Designer
Boeing
------------------------------