Join cells in Excel and remove excess commas between elements

Unclean data can cause a lot of problems in Excel. In this post I will show how you can join data from different columns with a comma between them. That’s the easy part. The problem occurs when you have empty cells in your data, like in the table below. The result of the first row looks fine, but if you look at the rows with empty cells, you get too many commas:

EasyExcel_41_1_Join with concatenate and trim


How to Create an HTML Table with Excel

If you write something for a webpage, chances are that you write the text in HTML code. If you’re used to it, it often turns out to be easier than writing the text in a What-you-see-is-what-you-get-editor (WYSIWYG). In my experience, the WYSIWYG-editors never really work the way you want, so the HTML editor turns out to be better after all.

But what if you want to use a table that you have created in Excel? How can you transform an Excel table into a piece of HTML code that looks like this?