How do I parse data in excel from every 4 rows to a new column

[gingit518]

Hi-

I want to create a 2 column spreadsheet like this :

Column A Column B
Trace A record of the processing of a computer program or transaction. The information collected from a trace can be used to assess problems and performance.
Transaction ID See transaction identifier

from
trace

A record of the processing of a computer program or transaction. The information collected from a trace can be used to assess problems and performance.

transaction ID

See transaction identifier.

transaction identifier (TID, transaction ID, XID)

Each item of data to create the column is seperated by 4 rows in excel now.

Please advise. Thanks.

[Excel Fox]

Why don't you just filter the rows for BLANKS and delete them?

[gingit518]

Why don't you just filter the rows for BLANKS and delete them?

Thanks that worked to remove the blanks. How do I move every other row into a column?

[AAE]

If you don't mind using a helper column you could enter this formula into the helper cells starting, say, on row-2

=IF(ISEVEN(ROW()),ROW(),""), copied down the column

The formula returns the row number if the row number is even

Let's say we use colum-C as the helper and we want to pull the data into column-D

In D2, copied down: =INDEX(A2:A100,MATCH(SMALL(C2:C100,ROW(A1)),C2:C10 0,0))
This pull values from every other row into column-A into column-D

To get column-B values into, say, column-E
In E2: =INDEX(B2:B100,MATCH(SMALL(C2:C100,ROW(A1)),C2:C10 0,0))

If the start row of your data begins on an odd numbered row, then use ISODD in place of ISEVEN.
Afterward, copy the D:E cells and paste back as values only then delete the helper cells.