Formatting Issue (Getting data from 1 column into 7 columns)

Subodh_Tiwari_sktneer 

Subodh/Sergei,

Your suggestions have been most helpful. I was finally able to get the data into the right format but it is a tremendous amount of work.  I'm working off of a prospect list web site where I have to input the specific parameters for the companies I want to discover (for example, location, industry, yearly revenue, etc.).  For large listings, I'm able to see only 25 companies at a time.  It looks like this:

I have to copy and paste each grouping of 25 into Excel and all of this info. goes into just one column.  When I've finally created a large enough list, I then run the Power Query that you've designed.  This is a lot of work because if each company doesn't have the exact same number of data points (in this case 7) the report is all jumbled and I have to go back and find where the missing data should go.  

Do you think I'm doing this in the most efficient way or is there a more economical way to go about this task.  I don't see how I can pull the info. right off the web site as I work because the web address just shows something like:  https://app.uplead.com/#.   I'm unsure if Excel can pull the exact info. that I've specifically collated on the site.

You gentlemen have been so very kind in your guidance and I sincerely appreciate it.

Regards,

Jeff

;lkjasdjf