|
|
#1
12-21-2015, 09:24 AM
|
|||
|
|||
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
12-21-2015, 07:10 PM
|
|||
|
|||
|
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?
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2013
Linear Mode
