Delimited Headers in one cell

Question

Hi there can someone delimit this for me. Thankss

Test.xlsx

Gawa · Answer

@Inactive User I'm sorry, I cannot find any difference in your Output expected results from the previously provided data.

unknown · Answer

I've managed to determine the expected output.

Output expected results.xlsx

Gawa · Answer

hi @Inactive User

I guess this data cannot be delimited, because it is impossible to know whitespace is delimiter of headers or delimiter of words.

For example, dataset contains:

Number Entry Date

This can be delimited to "Number" "Entry Date" or "Number Entry" "Date", but we cannot programmatically know which is correct.

At least, we need target number of columns to be delimited.