Rearrange data into another table

[golden2282]

There is a sheet of data, each item has 3 rows and there will be many more. I want to rearrange the 'Raw' data into the table on the 'Output' sheet. There is an example of the output up top and need to fill in the data below.

[JohnTopley]

Is the "real" data in EXACTLY the format shown in your example: are items numbered 1 to n with number in row containing the name?

And avoid MERGEd cells please: not necessary.

[JohnTopley]

Try in B9

Formulae as:

=INDEX(Data!$B$1:$B$1000,MATCH(ROWS($1:1),Data!$A$1:$A$1000,0)+1)

see attached

[golden2282]

there are actually no numbers in the file i'm working on. I just put those there for easier reference. Is it possible without any numbers? I agree, I never merge the cells myself.

[JohnTopley]

Does the data start in row 2 with a single blank line between each set?

[JohnTopley]

Try

in B

=INDEX(Data!$B$1:$B$1000,(ROWS($1:1)-1)*4+3)

in C

=INDEX(Data!$B$1:$B$1000,(ROWS($1:1)-1)*4+2)

in D

=INDEX(Data!$B$1:$B$1000,(ROWS($1:1)-1)*4+4)