Transposing rows into columns

[MSU-Library]

We are working with a list of items that we generated as a report and imported into excel from a text file. The list currently looks like this:

Number 0nam 2200409 a 4500
35 tmp979322
86 Y 4.F 76/2:S.HRG.110-734
245 U.N. peacekeeping [microform] : opportunities and challenges : hearing before the Subcommittee on International Operations and Organizations, Democracy, and Human Rights of the Committee on Foreign Relations, United States Senate, One Hundred Tenth Congress, second session, July 23, 2008.
260 Washington : U.S. G.P.O. : For sale by the Supt. of Docs., U.S. G.P.O., 2009.
490 S. hrg. ; 110-734
949 Y 4.F 76/2:S.HRG.110-734 1 BL-DCM
949 Y 4.F 76/2:S.HRG.110-734 1 BZRN-DCM
949 Y 4.F 76/2:S.HRG.110-734 1 NO-DCM




We would like to transpose the rows and columns. This is easy enough to accomplish individually with paste special. However, we have over 1400 citations to do. Any help would be appreciated.

 

[cgcamal]

Hi,

Do you want to transpose 1400 rows into 1400 columns?

May you show for the sample you've posted how would be the output for every row showed in this sample.

Regards

 

[MSU-Library]

Hi,

Do you want to transpose 1400 rows into 1400 columns?

May you show for the sample you've posted how would be the output for every row showed in this sample.

Regards

No we don't want 1400 columns. The sample represents one entry. We have 1400 entries of this type. We'd like each entry to be in a single row. Something like this:

number \ 35 \ 86 \ 245 \
0nam 2200409 a 4500 \ tmp979322 \ Y 4.F 76/2:S.HRG.110-734 \ U.N. peacekeeping [microform], etc


we want each entry to be in 9 rows so that all the numbers, 35s, 86s, 245s, 260s, 490s, 949s are in the same row. each entry would then start over on the next row.

Is that making sense? It is very hard to visually show it because this forum is not keeping my formatting.

 

[cgcamal]

To understand better, please try to show the input and output using Excel jeanie, MrExcel HTML Maker or
upload the excel file showing the input and output desired.

Regards