Hi all,
I have a spreadsheet that is several thousand rows long and the columns run from A:K. Column K has the data I'd like to split.
What I'd like to be able to do is:
1. Split Columns K into two columns, so that it becomes columns K & L;
2. Change column L to a bullet point format, so that when you click on the cell it appears as a bullet point list as opposed to all the data being mushed up on the one line.
Here is a screenshot: http://i.imgur.com/0q7srwP.png
Attached is also the spreadsheet with a current layout and the desired layout.
At present, my laborious solution involves the following:
- find and replace;
- text to columns;
- concatenate;
- transpose;
- cut and paste to notepad;
- copy and paste to excel.
Any help would be greatly appreciated
Bookmarks