I have a column with names like this >>>
GSGSRLSRSSPECIAL EDITION
BASE
GSGSRLSRSSESPECIAL EDITION LS
BASE
LXI
DXEXLXSE
CXDXEXLXVX
SSI
SI
VTEC
2.0 SI2.0 SI 4WS
S
DXEXLX
CXDXEXHX
S
EX
ALL
DXEXLXSE
I need to split each cell into different rows when there's more than a single value >>> I mean BASE and LXI, S are all single values, because there's nothing else so I don't have to do anything, my problem are DXEXLXSE, GSGSRLSRSSESPECIAL EDITION LS, etc
Because they have to be split in several rows and the content of each duplicated except for the value in the column, so it should go like this
DX
EX
LX
SE
each one in a separate row the rest is duplicated
Bookmarks