How to multiply each column in a libreoffice table with a value from another column in a different table?

[dpc]

Hi there!!! I have two tables.
Table:1

clade_name	DRR171959_profile	DRR171939_profile	DRR171934_profile	DRR171917_profile	DRR171899_profile
Methanobrevibacter_smithii	1	10	0	20	0
Actinomyces_cardiffensis	50	10	0	40	0
Actinomyces_graevenitzii	1	2	0	0	3
Actinomyces_johnsonii	0	0	3	5	0
Actinomyces_naeslundii	0	2	100	0	0
Actinomyces_odontolyticus	0	0	0.00219	0	0
Actinomyces_oris	0.0008	0.450	0	0.09	0

Table:2 (no header name in the original table)

DRR171899_profile	34008178
DRR171917_profile	56609267
DRR171934_profile	45460657
DRR171939_profile	50507602
DRR171959_profile	50970604

I want to multiply each column of table:1 with the corresponding values in second column of table:2. Can anyone please help me?

Thanks in advance,
dpc

[Hrbrgr]

81117 HB multiply each column.ods (18,2 KB)

You can define the first value in a group of 5 at a time and drag the selected cell down another 4 rows.

[keme1]

Wrong answer. Respondent must learn to read

The address of a table cell within a document consists of table name and cell coordinate “A1-reference”, separated by a period character. With that, a cell formula could appear as:

=<Table1.A4>*<Table3.C2>

See attached document for working examples.
WriterTableCalculation.odt (10.4 KB)

[erAck]

The question is tagged calc so the questioner quite certainly does not want a Writer solution… apart from that it does not what was asked.

[dpc]

Sorry @keme1 - It is not what I asked for.

[erAck]

You could either multiply all manually (tedious) or use VLOOKUP() with a defined named range for flexibility, the Profiles range can be adapted if new items are added and the formulas continue to work and can be copy-pasted to new columns. See attached
Ask-81117.ods (25.7 KB)

[LeroyG]

@erAck

multiply all manually

Sample file with some explanations: multiply columns.ods (12.8 KB)

[erAck]

Well, yes, I assumed they want to preserve the original values.