#1
|
|||
|
|||
Re-arranging data output into useable format
I have documents that I need certain pieces of information copied into an excel spread sheet. The documents may vary on length, but most of 20 - 30 pages log. If I do a good old copy paste into excel The data is all over the place, but it is grouped (somewhat) so that I know what goes with what. Attached is a small scale sample of my data. The sheet named "Raw" is exactly how my data looks. The sheet named "Desired Format" is how i would like it to look at the end of the day. Is what I'm looking for possible? |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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 |