[Solved] Append series of suffixes based on root

[cartoonjazz]

Hi, I'm a noob and not sure if this can be done in calc or in base
I have 1 table with a series of skus and prices
sku price
abc 10
def 20

and one table with possible suffixes that should be applied to each sku
99
58
65

the final table should look like this
abc99 10
abc58 10
abc65 10
def99 20
def58 20
def65 20

any help is appreciated

[RusselB]

Easily done in Calc, not sure about Base.
My question is, how is it determined which suffix should be applied the the SKU?

[Lupp]

Setspeak: Do you want to get concatenated all the possible "pairs" out of the Cartesian product "SetOfSku x SetOfSuffix" in a column?

[cartoonjazz]

I would like all possible suffixes applied to all skus

[Lupp]

Sigh.
I had hoped for a "YES" or "NO", probably followed by additional explanations.
Since I want to get this from my to-do, I take your answer for a "yes", and post my respective statements:

-0- Create a few helper columns, and don't be too reluctant with it. Helpers often are the essential means to get a clear and maintainable structure in spreadsheets.
Thus:
-1- Calculate the number of expected rows in advance and create a column simply giving the indices for the results from 1 to the highest.
-2a- Create a column for the index into the column of primary items (SKU in your case) per row of the results.
-2b- As I uderstand your question, this will also be the index into the column of values (prices in your case).
-2b-- Concerning this statement I don't actually believe it makes sense in the real world.
-3- Create a column for the index into the column of secondary items ("suffixes" in your case) per row of the results.
-3-- If you intend to treat things looking like numbers as strings, definitely make them being strings from the beginning: Apply the 'Numbers' format code '@' ('Text') to the respective cells (a column) .
-4- Create the column for the results to be concatenated from the entries in the primary and secondary column using the mentioned indices.
-5- Create the column for the additional values and fill it in the appropriate way - using the first index or not.

Depending on the situation you may then want to copy the results and to PasteSpecial them as constant content elsewhere.

What formulas you can use is shown in the attached example.

aoo101433rearrangeCartesianProductAsConcatenatedPairsInColumn_1.ods

(53.05 KiB) Downloaded 95 times

Your questions and your answers to questions in return might be in the future as thorough as -hopefully, at least intentionally- this answer is. Long series of incomplete posts are wasting time.

[Villeroy]

Trivial to do and easy to maintain in Base.

Tutorial: [SQL] JOINing 2 row sets

[cartoonjazz]

Thank you, the base method definitely easiest works great