Hi,

My spreadsheet has 4 columns of data but I need to convert just the 1 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 want data for but each stock is listed multiple time per interval
Column D has the actual values of the stocks at the diffferent intervals

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

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

Please help.

Thanks
Mohoney