Forum Discussion
Need help: How to Transform data from combined lists to separate options
Hi, does anyone know if there's an efficient way to transform columns of data as seen in left image below to a new set that looks like image on the right?
This looks like it could be solved with an IF statement:
=IF($A2="","",IF($A2=C$1,1,"")) for flavours.
=IF($A2="","",IF($B2=F$1,1,"")) for years.