Forum Discussion
Paragraphs and bulleted list using text to columns
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.
- It looks like maybe because not all job descriptions have all the sections. Can that be coded around? So if a section is not found, skip. If not, this is much better than what I had to begin with.
