I have a range of data in rows that I want to transpose into two columns
in Excel 2000. The first row is the header row that I want to repeat in
the left-hand column. Any ideas how to do this where I can specify
number of original rows to be converted (3 rows or 300 rows) I but can
use the same formula/macro with say a variable adjustment?

I thought about Edit-Paste Special - Transpose – but I need the data
in 2 columns and I need the first row to repeat each time on the left.


An example of what I’m looking to do is below

ORIGINAL
ID FIRST LAST ZIP
1 Bob Smith 63101
2 Jane Doe 63105

NEW TRANSFORMED DATA

ID 1
FIRST Bob
LAST Smith
ZIP 63101
ID 2
FIRST Jane
LAST Doe
ZIP 63105

Thanks in advance,
Darryl


--
wilsonds
------------------------------------------------------------------------
wilsonds's Profile: http://www.excelforum.com/member.php...o&userid=31932
View this thread: http://www.excelforum.com/showthread...hreadid=516579