Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert 1 row of data into Multiple columns
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. Please help. Thanks Mohoney |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert some data in the row to columns? | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
SUMIF and MULTIPLE DATA | Excel Discussion (Misc queries) | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
how to convert multiple columns of data into one single column? | Excel Worksheet Functions |