I have a spreadsheet that is generated in a difficult format to manipulate. A series of reports are generated in sequence in a worksheet. I wish to transpose some of the data from each report into a more usable format. Additionally the data is irregular.
Below is an example of the data in the spreadsheet.
Case Number DateReceived DateClosed AgencyDesc
DI-XX-XXX1 10/01/2014 05/18/2015 Department of Fun
Allegation Code Allegation Description Disposition
40 XXXXXXX EEEE YYYY JJJ
41 YYYYYY HHHHHH
43 ZZZZZ EEEE YYYY JJJ
DI-XX-XXX2 10/01/2014 10/02/2014 Federal Fire Department
Allegation Code Allegation Description Disposition
40 PPPPPPP YYYYY HHHHHGGGGGG
DI-XX-XXX3 10/01/2014 10/02/2014 Federal Fire Department
Allegation Code Allegation Description Disposition
I want to transpose this data to the following columns:
Case Number DateReceived DateClosed AgencyDesc Allegation Code Allegation Description Disposition
Bookmarks