| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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: Superplastizitt, Behlterbau, Kugelform, Fgen, Umformen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
| compare data from two tables with varying record numbers | Excel Worksheet Functions | |||
| How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
| Transpose rows to columns w/varying numbers of lines per record | Excel Worksheet Functions | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
Threaded Mode
