Identity and Access Management, Identity Governance

Given a set of data in one single column, and you need to transpose every N number of rows into columns in Excel. The first task is to figure out how many rows or lines of data corresponds to one set. Once you have figured out how many consecutive rows of data corresponds to one set or a single records, then next step is transpose the selected rows into columns.  Lets take a simple example, given a data as below in one single column. aaa1 aaa2 aaa3 bbb1 bbb2 bbb3 ccc1 ccc2 ccc3 The first thing is to figure out how many rows correspond to one set. To make it simpler, we can see aaa1,aaa2,aaa3 belong to one set, and similarly bbb1,bbb2,bbb3 belongs to a different set. Hence the data represents three different records. The objective is to transpose the 3 lines or rows of data into separate columns, as below showing 3 distinct records. aaa1  aaa2  aaa3 bbb1 bbb2  bbb3 ccc1  ccc2  ccc3 The data now can now be represented into a Table format with each row corresponding to one separate record