Forum Discussion
Solved
Spreading data contained in column A across to other columns to form a table
I have a copy and paste multi-line data from a web page which has all gone into column A. This isn't a text to column use case but one where I want to place data from column A into relevant headed ...
- Which solution is now appropriate to your desire?
Please do not forget that the VBA solution leaves one line free every 10 rows, so that all addresses of the column in the row can be kept apart.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
Melise1 , I took a shot at this using Power Query. It's now perfect since the data in the column A is not consistent. There is no pattern that holds for all items past the Sector. Take a look at the solution and let me know if maybe there's a way to describe the input data pattern that can be used to automate the task.
Melise1 , the tricky part is not every item has the same 10 parts. For example, "Little Wickets" does not have the "Sales" part and this makes it difficult to automate.
Little Wickets (East Midlands) Ltd Amusement And Recreation Services, Sports 441159248476 Nottingham, Nottinghamshire http://littlewickets.com/ 1 79 CRM You mentioned that you copied and pasted from a website. Does the website have the data formatted in a way that includes all the parts? Perhaps the manual copy/paste messed things up. Can you check to see if you can get a more consistent data set?
