Rows to Columns with Every Other Row Formula

[Debra Lucius]

Hello,

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? Thank you for your assistance

A	B	C	D	E
Row	Current Format	Course Number	Course Title	Course Description
1	ACT 5000 - Financial and Managerial Accounting	ACT 5000	Financial and Managerial Accounting	Financial statements, accrual accounting, statement of cash flows, financial reporting, cost behavior, cost-volume-profit analysis, activity based costing, profit planning, budgeting, flexible budgeting, segment profitability reporting, relevant cost data for decision making, transfer pricing, product and services pricing, and performance measuring including ROI, residual income, and balanced scorecard, including measures to analyze costs and factors associated with sustainability
2	(3 units) Financial statements, accrual accounting, statement of cash flows, financial reporting, cost behavior, cost-volume-profit analysis, activity based costing, profit planning, budgeting, flexible budgeting, segment profitability reporting, relevant cost data for decision making, transfer pricing, product and services pricing, and performance measuring including ROI, residual income, and balanced scorecard, including measures to analyze costs and factors associated with sustainability
3	ACT 6015 - Financial Reporting	ACT 6015	Financial Reporting	This course focuses on the principles and practices in the preparation and use of financial statements such as the balance sheet, income statement, the statement of cash flows and other documents for financial reporting. Significance and limitations of financial statements are studied to allow students making informed decisions based on the provided financial documents.
4	(3 units) This course focuses on the principles and practices in the preparation and use of financial statements such as the balance sheet, income statement, the statement of cash flows and other documents for financial reporting. Significance and limitations of financial statements are studied to allow students making informed decisions based on the provided financial documents.

<tbody>
</tbody>

 

[Debra Lucius]

Sorry, I don't understand what you wrote. I'm new VB and plan to research VB classes next month. Any suggestions? In the mean time, can you please provide step by step instructions.

 

[MickG]

Not sure who you are referring to, but hopefully this example may help !!!
https://app.box.com/s/7bwhjmfua1yvgos7bp3nrpzw77i9tkfj