Forum Discussion
Paragraphs and bulleted list using text to columns
I have a column in a spreadsheet with 2500 plus rows. Within the column, is basic job description information. So you have elements Job Summary, Job Description, Primary Responsibilities with various billeted lists separated by hard returns, Education Information, Preferences, and Skills and Competencies.
I need to parse the column so that the paragraphs stay together into new columns. So for example, I need to move Job Summary into a new column, Job Description into a new column, Primary Responsibilities into a new column (This includes each billeted list for every job), Education Information into a new column, etc.
I can separate into a new column based on the Hard Returns within the file, but it separates the primary responsibilities into a separate column for each bullet on the job. This means that I have to concatenate it back together and this becomes difficult because some jobs have 4 bullets while others may have 15 bullets. I am trying to find a way to separate to keep the major sections together based on m
11 Replies
Could you please submit sample file with dozen or so rows (not 2500+) to illustrate what do you mean.
SergeiBaklan Here is two rows of data from the spreadsheet. From the spreadsheet, you can see it is a basic job description all in one cell with Excel. I want to separate the one cell into multiple columns based on the major sections within the job description.
So I want the opening paragraph in one column, the Primary Responsibilities in the next column, Requirements in the 3rd column, Preferences in the fourth column and then Skills and Competencies in the 5th column.
The data greatly varies for each job description. So you could have 3 bullets in one primary responsibility and in in another job you could have 15.
Let me know if that helps.
lostvol , I used Power Query to get the information. Please add a few more Job Descriptions to the table in the "JobDescriptions" tab. Just paste in the rows starting A4 and the Table will automatically expand. Then click on Data->Refresh All to update the "Summary" tab. Let me know if this is what you are looking for.
