Hi,

I've a huge mix data in a data base and I'll like to transform it into a sorted table, the idea is like in the attached picture.

What kind of function I can use for this?

Thanks!

Attached Images

table.jpg (27.7 KB, 15 views)

If the data repeat every four rows, you could use a formula like:
=OFFSET($B$1,(ROW()-2)*4+COLUMN()-3,0)
where:
• 'Name' & 'Result' are in cells A1 & B1, respectively; and
• the formula is input into D2, then copied across to G2 and down as far as needed.
Naturally, you'd also type the a-d column headers in D1-G1.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]