I have a worksheet with seven columns. The seventh column has values separated by commas that belong to the same row (columns A - F). I would to take each value from the seventh column and create a new row adding the values from columns A - F for each row. I have attached an example with one of the rows. Excel-Example.xlsx
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.