Forum Discussion
PaulGalve
Aug 01, 2022Copper Contributor
combining unstructured/uneven columns
Hi - I have a csv and wanted to combine 4 columns and make a new datasets out of the semicolon-separated column(A). Problem is, Cols B-E are not structured. Can someone enlighten me?
Link to CSV: https://drive.google.com/file/d/1HODvumKwKw8UCBvJIbPHtnhjro7kGxTz/view?usp=sharing
Thanks,
Paul
1 Reply
- Riny_van_EekelenPlatinum Contributor
PaulGalve Start by NOT opening the csv file by just double-clicking on it. In stead, import the file with Power Query or the Legacy text import wizard.
The attached file is what I get.