Hi,

My spreadsheet has 4 columns of data but I need to convert just the
column into a row.

Example:

Column A has the date
Column B has the 30 minute intervals starting from 09:00 to 17:00
Column C has the 5 different stocks (ABL, AGL; ANG; BAW;SLM) I wan
data for but each stock is listed multiple time per interval
Column D has the actual values of the stocks at the diffferen
intervals

I need to convert column C into 5 columns but retain the other column
data applicable to the various stocks so its easy to view in
table-like format.

Using copy/paste/tranpose feauture in Excel is not my solution so i
has to be an array formula (I think!).

Please help.

Thanks
Mohone

--
Mohone
-----------------------------------------------------------------------
Mohoney's Profile: http://www.excelforum.com/member.php...fo&userid=2662
View this thread: http://www.excelforum.com/showthread.php?threadid=39897