Forum Discussion

LuisSiqueira's avatar
LuisSiqueira
Copper Contributor
Jun 22, 2020

Separating columns in Excel based on their values

I have a long excel list where column E is used for the "attribute Name" and Column F for the "Attribute Value". I need to break each attribute name into different columns and populate their respecti...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 23, 2020

LuisSiqueira Alternatively, look into "Text-to-columns". Use space as the separator. It will split the text into separate columns where-ever it finds a space. Make sure you have enough empty columns for the result to be placed into.

  • DevendraJain's avatar
    DevendraJain
    Iron Contributor
    Jun 23, 2020

    Riny_van_Eekelen You Can use Text to Column function but before that insert about 10 to 15 columns and if you dont do so then it will overwrite the attribute value columns

Resources