View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SerPetr SerPetr is offline
external usenet poster
 
Posts: 1
Default Transpose rows to columns with varying numbers of lines per record


I have a 2 column-datasheet with more than 1000 rows.

Example:

100: 6
190: 20020507217
200: Tsubakino, H.$Fukumoto, S.$Ono, #
204: Himeji
502: 3-88355-302-6
503: mw2001_529.pdf
561: 6S,6B,2T,6Q
565: Materials Week 2001, Internat. Congress on Adv
577: S.1-6

100: 6
130: EN
190: 20020507215
192: TIB-RR7407(2001)CD-R
200: Lutfullin, R.Y.$Kruglov, A.A.$Kaibyshev, O.A.
204: Russian Acad. of Sci. (RAS), RU
400: Superplastic forming of spherical vessels
502: 3-88355-302-6
503: mw2001_751.pdf
550: 2001
561: 6S,5B,1T,8Q
577: S.1-6
726: 3LF$3LNB$3KXM$3BA
740: Superplastizit„t, Beh„lterbau, Kugelform, Fgen, Umformen