I'm usually pretty good at googling what I need done in excel but here I am stuck for even what to google. Here's what I need.
I'm trying to import into a database a range of fitting types. Here is the google sheets version.
https://docs.google.com/spreadsheets/d/1DwrkzfNPjWKUePEsXkJeU0t6Tuy-gyDBgi1u0525dfM/edit?usp=sharing
Basically, for every type, I need it to have a row of every other option.
Ex
The first rows should be 180 Degree * Every Material * Unit of Measure *Type of Connection (I can leave out the connection size)
180 Degree | Aluminium | mm | m-45-Degree Flare
180 Degree | Aluminium | IN | m-45-Degree Flare
Hopefully, this makes sense.
Is there a way to make excel build this from the table I already have?
I'm trying to import into a database a range of fitting types. Here is the google sheets version.
https://docs.google.com/spreadsheets/d/1DwrkzfNPjWKUePEsXkJeU0t6Tuy-gyDBgi1u0525dfM/edit?usp=sharing
Basically, for every type, I need it to have a row of every other option.
Ex
The first rows should be 180 Degree * Every Material * Unit of Measure *Type of Connection (I can leave out the connection size)
180 Degree | Aluminium | mm | m-45-Degree Flare
180 Degree | Aluminium | IN | m-45-Degree Flare
Hopefully, this makes sense.
Is there a way to make excel build this from the table I already have?