The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Reload this Page Excel data manipulate
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Excel data manipulate
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 11-26-2008
rahulrathod rahulrathod is offline
Registered User
  
 

Join Date: Sep 2004
Location: Mumbai-India
Posts: 158
Lightbulb Excel data manipulate
All,

I have the following format of data in a spreadsheet


Code:
A	1
            2
            3
            4
B	1
            2
            3
            4

where 'A' is value of 'A1', '1 2 3 4' is value of cell B1, 'B' is value of cell A2, and '1 2 3 4' is value of cell B2.

There are thousands of rows with such a data format in the spreadsheet.

Is there any way which you can think where I can get this data in the followin format.


Code:
A          1
A          2
A          3
A          4
B          1
B          2
B          3
B          4

I was thinking if I could convert the spreadsheet to a csv and do some manipulations using sheel script.

The above is just an example format. the data in the cells in spreadsheet may be different.

Regards,
Rahul.