StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Another way that involves no code or formulas is to insert a few extra columns containing HTML tags... </p> <p>To see this copy this text, select a cell in Excel and choose <em>Paste Special > Text</em>. </p> <pre><code><Table><td> Name <td> ID <td> Image <tr><td> product 1 <td> 111 <td> image111A.jpg <td> image111B.jpg <tr><td> product 2 <td> 222 <td> image222A.jpg <td> image222B.jpg <td> image222C.jpg <tr><td> product 3 <td> 333 <td> image333A.jpg <td> image333B.jpg </code></pre> <p>The result is shown in the screenshot below. To create this layout: </p> <ul> <li>insert extra columns between the fields </li> <li>enter the title rows </li> <li>fill down all lines with the lines containing the comment characters. </li> <li>Select the Name Column and choose Advanced <em>Filter > Unique values > OK</em> </li> <li>fill down the values for the first line of each product.</li> </ul> <p><img src="https://i.stack.imgur.com/bHlnh.png" alt="enter image description here"></p> <p>Now copy and paste as text. To do this you can <em>either</em></p> <ul> <li>copy to notepad, select all text and copy and paste in Excel, <em>or</em> </li> <li>activate the office clipboard, copy and paste by clicking the icon then choose <em>Paste-Special text</em>.</li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload