My spreadsheet has variable number of comma separated entries in multiple columns. I need to calculate for each column the max number of entries, insert this many blank columns and then run the text to columns function. Then I need to repeat this on any other columns in the spreadsheet that have more than 1 comma separated entry. For example:
Column 1: Row 1 = 2 entries, Row 3 = 5 entries
Column 2: Row 1 = 6 entries, Row 30 = 4 entries
Thanks in advance.