#1
|
|||
|
|||
Data sorting in table
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! |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Sorting while on Protection mode | ioannidis.dim | Excel | 2 | 05-25-2016 12:16 AM |
sorting data while in a protected workbook | Andy Francis | Excel | 0 | 06-06-2015 01:35 AM |
Data sorting with headers | saxydj | Excel | 4 | 02-02-2015 12:40 PM |
Data Sorting Question | AQWst | Excel | 4 | 02-02-2015 11:37 AM |
Sorting blocks of data | GenPerson | Excel | 0 | 11-29-2012 02:46 AM |