Recent content by DataExpert

  1. D

    Excel - Split rows into columns

    Hello, Assuming that your 2 snapshots are on the same worksheet, copy the following formula into cell F2, and drag both down and accross. Should give you what you are looking for as long as your data is in the same format... =OFFSET($C$2,(ROW()-2)*5+COLUMN()-6,0) Give me a shout if you...