How would I go about splitting the following sheet into the second sheet. Im looking for column d to contain a |
if it does, split column by commas and create new rows.
Input example
title
color
day
size
owner
ford
blue
mon
10
john
chev
red
tue
8.1|8.2, 8.3
joe
Output example
title...