I have encountered a problem while working on MS excel. So, I have data in multiple lines (alt + enter) in consecutive columns. Now, I have tried to use the power query delimiter tool to separate these values into rows. But that has really increased the number of entries.
What I want is that the line feed data in each column should correspond to the line feed data in the other column. Any suggestions would be appreciated.