topic RE: Pulling Collection by Row Data in Product Forum https://community.blueprism.com/t5/Product-Forum/Pulling-Collection-by-Row-Data/m-p/92316#M42128 Use the Transpose Collection Action under Utility - Collection Manipulation.<BR /><BR />------------------------------<BR />Ahmed Basheer M<BR />RPA Developer<BR />Capgemini India<BR />Asia/Kolkata<BR />------------------------------<BR /> Thu, 26 Sep 2019 10:33:00 GMT AhmedBasheer_M 2019-09-26T10:33:00Z Pulling Collection by Row Data https://community.blueprism.com/t5/Product-Forum/Pulling-Collection-by-Row-Data/m-p/92315#M42127 ​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:<BR /><BR /><STRONG>Name</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jeff<BR /><STRONG>Age</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24<BR /><STRONG>Sex</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;M<BR /><STRONG>City</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NYC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;STL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SEA<BR /><BR />In this scenario I would want Name, Age, Sex, and City to be the Fields in the collection<BR /><BR />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.<BR /><BR />------------------------------<BR />Josh Harris<BR />Solution Designer<BR />Boeing<BR />------------------------------<BR /> Wed, 25 Sep 2019 19:56:00 GMT https://community.blueprism.com/t5/Product-Forum/Pulling-Collection-by-Row-Data/m-p/92315#M42127 JoshHarris 2019-09-25T19:56:00Z RE: Pulling Collection by Row Data https://community.blueprism.com/t5/Product-Forum/Pulling-Collection-by-Row-Data/m-p/92316#M42128 Use the Transpose Collection Action under Utility - Collection Manipulation.<BR /><BR />------------------------------<BR />Ahmed Basheer M<BR />RPA Developer<BR />Capgemini India<BR />Asia/Kolkata<BR />------------------------------<BR /> Thu, 26 Sep 2019 10:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Pulling-Collection-by-Row-Data/m-p/92316#M42128 AhmedBasheer_M 2019-09-26T10:33:00Z