Adding data from cells b/c/d into a the right place in cell A

[Alex_spreadsheet]

Hello,


I am trying to build html for a series of product pages. To do this I am trying to create a table, with data held in various columns in a spreadsheet.


The data from column b/c/d/e needs to go where the ???? are which is a cell in column A, which I can then insert into the product pages. I would do it manually but there are thousands of products so I wondered if anyone knew a way of using a function to do this?


<table style="width:40%">
<tr>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
</tr>
<tr>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
</tr>


I have this data in the columns including height, width, colour etc.


Anyone got an idea?


Thank for your help!
Alex

 

[Alex_spreadsheet]

Sorry this was the table not sure why it is missing from above!


<table style="width:40%">
<tr>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
</tr>
<tr>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
<td>
<php> echo tep_image('images/XXX', '', 30, 30); </php> <span style="color:#A9A9A9; font-size:18px;"> ?????</span>
</div></td>
</tr>

 

[Myrko]

Hi Alex,

I am not sure if you want to move all values from b/c/d (or more columns) into the same row of column A, all together (in this case, you can use CONCATENATE function) or just certain of values from all mentioned columns?

Can you please provide more details so I can assist you?

Thanks,
Mirko

 

[Alex_spreadsheet]

Hi Alex,

I am not sure if you want to move all values from b/c/d (or more columns) into the same row of column A, all together (in this case, you can use CONCATENATE function) or just certain of values from all mentioned columns?

Can you please provide more details so I can assist you?

Thanks,
Mirko

Hi Mirko,

No they need to go into separate parts of the text within the cell - here a simplified version;

<A2>
Row 1 of table Cost: [insert data from cell B2]
Row 2 of table Height: [insert data from cell C2]
Row 3 of table Colour: [insert data from cell D2]
</A2>

Thanks!

 

[Myrko]

Ok, let me just ask something else before I propose a solution (so we don't go back and forth if I didn't understand everything right):
So you will have a table with inputs (height, weight, color) in columns (thousands of rows) and you want to store the data transposed, as a part of your pre-defined text in column A (second row of inputs will be added to the column B of output)?

Input
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]22[/TD]
[TD]33[/TD]
[TD]Red[/TD]
[TD]13kg[/TD]
[TD]1yrs[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]22[/TD]
[TD]Blue[/TD]
[TD]11kg[/TD]
[TD]2yrs[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]15[/TD]
[TD]Black[/TD]
[TD]0.7kg[/TD]
[TD]0.2yrs[/TD]
[/TR]
</tbody>[/TABLE]

Output
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Height 22[/TD]
[TD]Height 11[/TD]
[TD]Height 7[/TD]
[/TR]
[TR]
[TD]Width 33[/TD]
[TD]Width 22[/TD]
[TD]Width 15[/TD]
[/TR]
[TR]
[TD]Color Red[/TD]
[TD]Color Blue[/TD]
[TD]Color Black[/TD]
[/TR]
[TR]
[TD]Weight 13kg[/TD]
[TD]Weight 11kg[/TD]
[TD]Weight 0.7kg[/TD]
[/TR]
[TR]
[TD]Age 1yrs[/TD]
[TD]Age 2yrs[/TD]
[TD]Age 0.2yrs[/TD]
[/TR]
</tbody>[/TABLE]

I have used dummy text in my tables (height, weight, color, width and age), just for a demo. And you wanted data added to the place of text where you mark (with ????? or whichever text you use as a mark)?

 

[Alex_spreadsheet]

Hi,

Yes that looks like exactly what I want please!

This will then allow me to generate 1 table for each product from the data in column b/c/d/e.

Thanks,
Alex