Combine rows into a single cell based on word match

Pete2020

Board Regular
Joined
Apr 25, 2020
Messages
68
Office Version
  1. 2016
Platform
  1. Windows
I am facing a difficulty in merging the row data into a single cell. based on certain word match in column B. I am looking for a VBA or excel custom function.

If the word match in column B (it should not compare word with is part of another word), it should merge the rows.

However,if any particular word not matched, it should display as not found.

The data should be Populated in Column F and G.



Book6
ABCDEFG
1IDTopicsIDColumn B output - with delimiter "|" Pipe
2Course1726Course Objectives: Course1726Course Objectives: | After completion of the course the learners will be able to-|Discuss the meaning, nature and scope of Educational sociology and Relation between Education and Sociology.|Describe the Social factor and their relation to Education.|Define social groups, socialization and Social Institution and Agencies of Education.|Explain the Social change and its impact on Education.
3Course1726After completion of the course the learners will be able to- Course1726Unit-1: Educational Sociology|Meaning, nature and scope of Educational sociology.|Relation between education and sociology.|Concept of Educational sociology and sociology of education.
4Course1726Discuss the meaning, nature and scope of Educational sociology and Relation between Education and Sociology. Course1726Unit-2: Social factors, issues and Education|Culture: Concept, role of education in culture, cultural lag.|Social issues: unemployment, poverty, disadvantage section of Indian society (SC, ST and OBC).
5Course1726Describe the Social factor and their relation to Education. Course1726Unit-3: Social groups and Education|Social groups- meaning and types (Primary, Secondary and Tertiary)|Socialization: Meaning, process and factors of socialization, role of the family and school.|Social Institutions and Agencies of Education: (i) Family, (ii) School.
6Course1726Define social groups, socialization and Social Institution and Agencies of Education. Course1726Unit-4: Social change and Education|Social change: definition, characteristics, factors, constraints|Education and social stratification: Definition and characteristics|Education and Social Mobility
7Course1726Explain the Social change and its impact on Education. Course1726SuggestedBooks:|Y. K. Sharma – Sociological Philosophy of Education|S. S. Ravi – A Comprehensive Study of Education|J. C. Aggarwal – Philosophical and Sociological Bases of Education
8Course1726Unit-1: Educational Sociology Course1727Course Objectives:|After completion the course the learners will be able to:|Describe the concept of Central tendency and their properties|Explain the concept of measures of variability and their properties|Describe the concept of co-relation and their application
9Course1726Meaning, nature and scope of Educational sociology. Course1727Unit-A: Descriptive Statistics|Meaning of Central Tendency- Mean, Median and Mode-their Properties, Calculation and Application.|Measure of Variability- Range, SD and – their Properties, Calculation and Application
10Course1726Relation between education and sociology. Course1727Unit-B: Coefficient of correlation|Concept of Correlation – Computation of Co-efficient of Correlation by Rank difference method and Product moment method, Interpretation of Co-efficient of Correlation,
11Course1726Concept of Educational sociology and sociology of education. Course1727SuggestedBooks:|S. K. Mangal- Statistics in Education and Psychology|A. K. Singh – Test, Measurement and Research Methods in Behavioural Sciences|H.E. Garret- Statistics in Education and Psychology|R. A. Sharma- Mental Measurement and Evaluation|Y. P. Aggarwal- Statistics Methods Concepts, Application and Computation
12Course1726Unit-2: Social factors, issues and Education Course1728Course Objectives:|After completion of the course the learners will be able to:|Define Achievement Test|Explain the characteristics of Achievement Test|State the objectives of Achievement Test|Discuss the functions of Achievement Test|Describe the steps of constructing Achievement test|Construct Achievement test
13Course1726Culture: Concept, role of education in culture, cultural lag. Course1728Unit-I: Concept of Achievement test|Meaning & definition of Achievement test|Characteristics of Achievement Test|Objectives of Achievement Test
14Course1726Social issues: unemployment, poverty, disadvantage section of Indian society (SC, ST and OBC). Course1728Unit-II: Different aspects of Achievement Test|Principles of Achievement test construction|Steps involved in the construction of Achievement Test
15Course1726Unit-3 Social groups and Education Course1728SuggestedBooks | Not found
16Course1726Social groups- meaning and types (Primary, Secondary and Tertiary) Course1729Course Objectives | Not found
17Course1726Socialization: Meaning, process and factors of socialization, role of the family and school. Course1729First Unit|Charter Act of 1813 and its educational significance|Macaulay Minuets- (1835)- its educational significance|Bengal Renaissance- Contribution of Raja Ram Mohan Roy & Derozio.|Wood’s Despatch (1854) and its impact on education.|Indian Education Commission (1882-83) and its impact of education.
18Course1726Social Institutions and Agencies of Education: (i) Family, (ii) School. Course1729Seond Unit|Educational reformer Lord Curzon|National education movement- Causes, Phases and Importance in Education.|Basic Education- Concept, characteristics, merits and demerits.|Sargent Plan Report (1944)- Pre-primary education, Primary education, Secondary education, Vocational & Technical education.
19Course1726Unit-4: Social change and Education Course1729Third Unit: |University Education Commission (1948-49) -Aims and Objective, Rural University Examination System, Teacher and Teaching Education, Vocational Education, Women Education.|Secondary Education Commission (1952-53) -Structure of Education system, Aims and Objective, Curriculum and Evaluation system and Language Policy|Indian Education Commission (1964-66) – Structure of Education system, Aims and Objective, Curriculum, Language Policy, Exam System and Teacher Education, Equality in Educational Opportunity.
20Course1726Social change: definition, characteristics, factors, constraints Course1729Fourth Unit:|National Policy on Education (1986) -National System of Education, Equality in Education, ECCE, Operation Black Board, NavadayVidyalaya.|Revised National Policy on Education-1992.
21Course1726Education and social stratification: Definition and characteristics Course1729SuggestedBooks:|B. R. Purkait- Milestones of Modern Indian Education|J. C. Aggarwal – Landmarks in the History of Modern Indian Education|S. S. Ravi – A Comprehensive Study of Education|J. P. Banerjee – Education in India: Past, Present and Future|S. P. Chaube & A. Chaube – Education in Ancient and Medieval India|B. K. Nayak- History Heritage and Development of Indian Education|B. N. Dash –History of Education in India
22Course1726Education and Social Mobility
23Course1726SuggestedBooks:
24Course1726Y. K. Sharma – Sociological Philosophy of Education
25Course1726S. S. Ravi – A Comprehensive Study of Education
26Course1726J. C. Aggarwal – Philosophical and Sociological Bases of Education
27Course1727Course Objectives:
28Course1727After completion the course the learners will be able to:
29Course1727Describe the concept of Central tendency and their properties
30Course1727Explain the concept of measures of variability and their properties
31Course1727Describe the concept of co-relation and their application
32Course1727Unit-A: Descriptive Statistics
33Course1727Meaning of Central Tendency- Mean, Median and Mode-their Properties, Calculation and Application.
34Course1727Measure of Variability- Range, SD and – their Properties, Calculation and Application
35Course1727Unit-B: Coefficient of correlation
36Course1727Concept of Correlation – Computation of Co-efficient of Correlation by Rank difference method and Product moment method, Interpretation of Co-efficient of Correlation,
37Course1727SuggestedBooks:
38Course1727S. K. Mangal- Statistics in Education and Psychology
39Course1727A. K. Singh – Test, Measurement and Research Methods in Behavioural Sciences
40Course1727H.E. Garret- Statistics in Education and Psychology
41Course1727R. A. Sharma- Mental Measurement and Evaluation
42Course1727Y. P. Aggarwal- Statistics Methods Concepts, Application and Computation
43Course1728Course Objectives:
44Course1728After completion of the course the learners will be able to:
45Course1728Define Achievement Test
46Course1728Explain the characteristics of Achievement Test
47Course1728State the objectives of Achievement Test
48Course1728Discuss the functions of Achievement Test
49Course1728Describe the steps of constructing Achievement test
50Course1728Construct Achievement test
51Course1728Unit-I: Concept of Achievement test
52Course1728Meaning & definition of Achievement test
53Course1728Characteristics of Achievement Test
54Course1728Objectives of Achievement Test
55Course1728Unit-II: Different aspects of Achievement Test
56Course1728Principles of Achievement test construction
57Course1728Steps involved in the construction of Achievement Test
58Course1729First Unit
59Course1729Charter Act of 1813 and its educational significance
60Course1729Macaulay Minuets- (1835)- its educational significance
61Course1729Bengal Renaissance- Contribution of Raja Ram Mohan Roy & Derozio.
62Course1729Wood’s Despatch (1854) and its impact on education.
63Course1729Indian Education Commission (1882-83) and its impact of education.
64Course1729Second Unit
65Course1729Educational reformer Lord Curzon
66Course1729National education movement- Causes, Phases and Importance in Education.
67Course1729Basic Education- Concept, characteristics, merits and demerits.
68Course1729Sargent Plan Report (1944)- Pre-primary education, Primary education, Secondary education, Vocational & Technical education.
69Course1729Third Unit
70Course1729University Education Commission (1948-49) -Aims and Objective, Rural University Examination System, Teacher and Teaching Education, Vocational Education, Women Education.
71Course1729Secondary Education Commission (1952-53) -Structure of Education system, Aims and Objective, Curriculum and Evaluation system and Language Policy
72Course1729c) Indian Education Commission (1964-66) – Structure of Education system, Aims and Objective, Curriculum, Language Policy, Exam System and Teacher Education, Equality in Educational Opportunity.
73Course1729Fourth Unit
74Course1729National Policy on Education (1986) -National System of Education, Equality in Education, ECCE, Operation Black Board, NavadayVidyalaya.
75Course1729Revised National Policy on Education-1992.
76Course1729SuggestedBooks:
77Course1729B. R. Purkait- Milestones of Modern Indian Education
78Course1729J. C. Aggarwal – Landmarks in the History of Modern Indian Education
79Course1729S. S. Ravi – A Comprehensive Study of Education
80Course1729J. P. Banerjee – Education in India: Past, Present and Future
81Course1729S. P. Chaube & A. Chaube – Education in Ancient and Medieval India
82Course1729B. K. Nayak- History Heritage and Development of Indian Education
83Course1729B. N. Dash –History of Education in India
Sheet1
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

BenMcBen

New Member
Joined
Aug 19, 2014
Messages
13
I think you need to expand on your problem some more - its not entirely clear to me on what basis rows should be joined
 

Pete2020

Board Regular
Joined
Apr 25, 2020
Messages
68
Office Version
  1. 2016
Platform
  1. Windows
Based on Column A which is a primary key and the rows of column B to be merged in a single cell.

Rules relating to merge rows into single cell for column B
-Based on Column A(UniqueID), if column B contains word like "Course Objectives","Unit" and suggestedBooks, then the rows between them to be merged with a demliter "|" as seperator within a cell
- If that specified words like "Course Objectives","Unit" and suggestedBooks, NOT Found in column B, then it should display as not found in the merged cell (Please course 1728 an 1729 do not have suggested books and course objectives respectively).

- The out put should be displayed in Column F and G as shown in the above example

Thats it.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,983
Messages
5,621,966
Members
415,869
Latest member
LWSkinner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top