Arranging complex/Irregular data into the desired format

[Tarique Imtiyaz]

Hello Experts,

I have an excel spreadsheet that has one column (A1:A8300) and i want to logically re-arrange it based on below requirements:

1. The first cell has a Requirement ID (Irregular Format- eg: 2.1 ; 2.1.1; 2.1.1.1 etc).
2. Below the Requirement ID there is Requirement description spread across multiple rows [not fixed, i.e: for a Requirement ID in A(1), the description will be in A2:A(n)].
3. Then again a requirement ID in the next cell after the end of first description.
4. Again the description of that requirement as in Step 2.
5. Like wise i have the data spread across the 8300 cells.

What i need: From the raw data i want to create a spreadsheet which has Requirement ID in one column and its description in second column.


Example:

A1: 1.1
A2: User must be
A3: able to login
A4: using the admin credentials
A5: 1.1.1
A6: An error will
A7: be displayed if the incorrect credential is used.
A8: 1.2
.
.
.
.

and i want this to be displayed as:

A1: 1.1
B1: User must be able to login using the admin credentials
A2: 1.1.1
B2: An error will be displayed if the incorrect credential is used.
A3: 1.2
B3: .............


Thanks in advance !!

 

[NARAYANK991]

Hi ,

Please upload a sample workbook with enough data in it.

Narayan