Raw HTML to table

[neuronsoup]

Hello World,

Greetings from Manchester, England.

If someone would be kind enough to supply me with knowledge of a formula based approach to my problem, I promise to pay your kindness forward to some unsuspecting stranger IRL.

I have put my excel file into a google drive folder at the bottom of this post. I have spent a good 24 hours on this and I can usually make excel submit to my will. (usually).

I have an online restaurant menu, complete with products, their names, descriptions, variances and prices.

I copy and paste the raw HTML code into an excel sheet. In another sheet i catch instances of the information i want from the lines of code. In another sheet i remove the blanks and rank their instance.

The tricky part comes with trying to get this information into a final and legible table.

Where for example:

Product #x - 1 Product name - 1 description - 0 variance - 1 price
Product #y - 1 Product name - 0 description - 2 variance - 2 price
(On this line product y needs to be carried, listing the 2nd instances).

The best case scenario is like the above or the attached image -

The use case - I want to parse 200+ menus to find at a glance prices for all of their items then put all of this data into one beautiful mammoth Microsoft Power BI report.

I do not think I will find a solution myself. Especially considering that if you were to quickly analyse the data in the sheet "Paste Values & Remove Blanks" you will find on row 616 a sauce product with 23 variations.

Please kindly help me if able.

Adam

**drive.google.com/open?id=1DKCNWtgSJ57T0h9w07Qhz5FLH422Mxvf**

[AliGW]

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Some members are reluctant to follow external links.

[neuronsoup]

Hi AliGW,

Cheers for the info, i thought I was limited as I am a new user to the forum. Got by all these years!

It's less of a sample workbook and more of the entire thing. It does follow a pretty easy to understand pattern though.

Adam