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?
|