Hi, I have a column that has data within each cell that needs to be delimited using Text to Columns at the Tab and Other: "-" level. (Data should output into consecutive columns to the right without overriding columns with existing data). If I do this manually, I typically have to insert around 8 rows to account for all delimited data (sometimes I'll receive 3 columns with delimited data, or 4 or five depending on the data dump). I then need to concatenate all columns FOLLOWING the delimited column that hold data into a SINGLE column. And delete all columns that have no data. So, I should end up with just 2 columns in the end. Also, I have to exclude the cell at the top of the delimited column as it includes the header, and, in the past, when I tried to delimit the WHOLE column it occasionally throws the data off by a cell (so I select the range from A2 down the column to last cell in column containing data). I hope this is clear. Please help! Thanks in advance.
Bookmarks