Hello,
hope you guys can hep me with this problem. Below is an example of what my file looks like.
I would like to create a unique ID in column A by concatenating the Types in column C and the Product ID also in column C above each table.
So for Product A, the expected result in column A should be: 1Product A, 2ProductA and so on (or Product A1, Product A2, whatever)
Of course I have no idea how this could be achieved.
Many thanks.
<tbody>
</tbody>
hope you guys can hep me with this problem. Below is an example of what my file looks like.
I would like to create a unique ID in column A by concatenating the Types in column C and the Product ID also in column C above each table.
So for Product A, the expected result in column A should be: 1Product A, 2ProductA and so on (or Product A1, Product A2, whatever)
Of course I have no idea how this could be achieved.
Many thanks.
A | B | C | |||||||
Product A | |||||||||
Type | Quantity | Price | Value | ||||||
=1ProductA | 1 | ||||||||
=2ProductA | 2 | ||||||||
=3ProductA | 3 | ||||||||
Product B | |||||||||
Type | Quantity | Price | Value | ||||||
=1ProductB | 1 | ||||||||
=2ProductB | 2 | ||||||||
=3ProductB | 3 | ||||||||
<tbody>
</tbody>