Re-arranging data output into useable format

macropod · #1 11-15-2013, 10:17 PM

In A2 put: =OFFSET(Raw!$B$3,(ROW()-2)*8,,)
In B2 put: =OFFSET(Raw!$G$6,(ROW()-2)*8,,)
In C2 put: =OFFSET(Raw!$E$6,(ROW()-2)*8,,)
In D2 put: =OFFSET(Raw!$D$6,(ROW()-2)*8,,)
In E2 put: =OFFSET(Raw!$C$3,(ROW()-2)*8,,)

Copy all formulae down as far as needed.

bremen22 · #2 11-18-2013, 10:32 AM

My apologies for taking so long to respond. Thank you for that formula. It was exactly what I needed. Worked like a charm

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Format: how to output dates that are not US?	tinfanide	Word VBA	0	10-28-2013 03:30 AM
Mailmerge Data Format	tombradley	Mail Merge	1	09-29-2013 07:35 PM
Changing format of time data	Sammael	Excel	2	04-08-2012 12:13 PM
Effects list re-arranging	Buzzman	PowerPoint	0	11-21-2011 08:46 PM
Arranging Into Groups	skoz55	Excel	1	09-07-2011 12:02 AM