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

22	33	Red	13kg	1yrs
11	22	Blue	11kg	2yrs
7	15	Black	0.7kg	0.2yrs

<tbody>
</tbody>

Output

Height 22	Height 11	Height 7
Width 33	Width 22	Width 15
Color Red	Color Blue	Color Black
Weight 13kg	Weight 11kg	Weight 0.7kg
Age 1yrs	Age 2yrs	Age 0.2yrs

<tbody>
</tbody>

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