If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
#2
|
|||
|
|||
Use Tools, Options, Text to Columns
if you actually have commas separating, you would choose delimited and on the next dialog select comma as your delimiter. Make sure you have the requisite empty columns to the right, before starting. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mohoney" wrote in message ... 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
How to have multiple columns in pivot table data area? | mitch1962 | Worksheet Functions | 2 | February 24th, 2005 07:42 AM |
Finding common data in multiple columns and rows in Excel | sparham | Worksheet Functions | 3 | February 12th, 2005 04:11 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
How to compare Multiple Rows and Columns to get data | Lee Li [MSFT] | Setting up and Configuration | 0 | September 15th, 2003 09:09 AM |