Rows in columns

G

gary

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: :

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transposing 1
Segregate Outstanding Payment 1
Trend Analysis 0
update query to remove parenthesis 5
How to ignore a column of numbers in Grand Total for rows 1
Calculation based on year of entry 1
move cells up 6
Unexpected issue with VBA code received 2

Top