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
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

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 23, 2020

DevendraJain ???? Why respond to me with a suggestion that I had already made myself?

Resources