#1
|
|||
|
|||
Rows to Columns with Every Other Row Formula
I'm working with a Word Document that includes course number, course title and course description. I saved the document as a .txt file and used Excel to open the .txt file. The current Excel format is one column; one row contains course number and title and the row directly below contains course description. My goal is to add 3 additional columns to include course number, course title, and course description. Course description needs to included the information from Col B and insert description into column E. In the example below B1 data should appear in C1 and D1; B2 should appear in E1 without (Course Credits). Is this possible? Please see attachment for example. Thank you for your assistance |
#2
|
|||
|
|||
Can you upload of a copy of how it is displaying when you open the TXT in Excel so I can see what you mean?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving from Rows to Columns | jimmydd2121 | Excel | 1 | 06-02-2014 09:05 AM |
Stack columns into rows | stellag09 | Excel | 1 | 04-23-2014 03:26 AM |
Changing rows into columns | paapachak | Word Tables | 8 | 01-06-2014 02:44 PM |
Adding columns in specific rows only | mhays | Excel | 5 | 01-17-2012 09:13 AM |
Rows to Columns | kyakobi | Excel | 5 | 12-07-2010 03:12 PM |