Transposing

Giganews Newsgroups
Subject: Transposing
Posted by:  gary (gcotte…@co.riverside.ca.us)
Date: Sat, 12 Jul 2008

The cells in Col A contain the following data:

ASMNT
2005
00000
TOTAL
PAID
SITUS
PAREN
ASMNT
2005
2006
00000
28527
TOTAL
PAID
SITUS
PAREN
ASMNT
2005
00000
TOTAL
PAID
SITUS
PAREN
ASMNT
2004
2005
00000
TOTAL
PAID
SITUS
PAREN
ASMNT
2005
2006
00000
TOTAL
PAID
SITUS
PAREN
ASMNT
00000
28527
TOTAL
PAID
SITUS
PAREN
ASMNT
2005
2006
00000
28527
TOTAL
PAID
SITUS
PAREN

How can I "transpose" the cells to look like this
(Note: Each cell from Col A is in a different cell in each row).

ASMNT ASMNT 2005 00000 TOTAL PAID SITUS PAREN
2005
00000
TOTAL
PAID
SITUS
PAREN
ASMNT ASMNT 2005 2006 00000 28527 TOTAL PAID SITUS PAREN
2005
2006
00000
28527
TOTAL
PAID
SITUS
PAREN
ASMNT ASMNT 2005 00000 TOTAL PAID SITUS PAREN
2005
00000
TOTAL
PAID
SITUS
PAREN
ASMNT ASMNT 2004 2005 00000 TOTAL PAID SITUS PAREN
2004
2005
00000
TOTAL
PAID
SITUS
PAREN
ASMNT ASMNT 2005 2006 00000 TOTAL PAID SITUS PAREN
2005
2006
00000
TOTAL
PAID
SITUS
PAREN
ASMNT ASMNT 00000 28527 TOTAL PAID SITUS PAREN
00000
28527
TOTAL
PAID
SITUS
PAREN
ASMNT ASMNT 2005 2006 00000 28527 TOTAL PAID SITUS PAREN
2005
2006
00000
28527
TOTAL
PAID
SITUS
PAREN

(My spreadsheet has 60,000 cells in COL A)

Replies