Forum Discussion

PaulGalve's avatar
PaulGalve
Copper Contributor
Aug 02, 2022

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:  Raw Data

Thanks,

Paul

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 02, 2022

    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.

Resources