Hi

If I understand your problem correctly, then column a contains your field
names, repeated for each record.
Copy A1:A13 and Paste SpecialTranspose to cell E1.
Your Field names will now be listed in E1:Q1

In cell E2 enter the following formula
=OFFSET($E$1,(COLUMN()-5+(ROW()-2)*14),-3)
Copy this formula across through cells F2:Q2
Then copy E2:Q2 down through as many rows as you require and this will pull
in the numeric values from each record

--
Regards
Roger Govier
"doran_doran"
wrote in message
...

Hi Excel Girl,

I tried that and it's working for one record. Actually it works for
multiple records but it's the second or third record after 13th column
then so forth. hmm any other ideas??


--
doran_doran
------------------------------------------------------------------------
doran_doran's Profile:
http://www.excelforum.com/member.php...o&userid=25274
View this thread: http://www.excelforum.com/showthread...hreadid=387655