Table into a single Cell

[ccv]

I'm using Excel for Mac and I want to add a table into a single cell.

I can't find out how to do it.

Hope you guys can help out.

[Pauleyb]

*Does Not Compute!*

Please clarify. A single cell cannot hold an entire table. You can put the image of a table in a cell. You can create one big cell and format it to look like a table is in it. Or, do you want to paste a table into an area that starts at a cell?

Pauley

[ccv]

Ok I need to import CSV files into the backend ofmy website.

Every row represents a product
Per column it describes what is what ( A:brand, B:product name, C:specs, D:price, E: manufacture etc.

In the column C:specs I want to add a table per Cell

Example:

[Pauleyb]

Personally, I would recommend creating separate columns for the specs (i.e. Input, Output, etc.). This would allow you to later sort/filter for certain specs if needed and is a 'cleaner' method.

You could, however, create a similar look by using merged cells. Assuming your spec table is 6 rows, then data in your brand, product, and price would actually be 6 merged rows. Then in the spec column you would have the 6 rows to add your other data.

Be warned, performing other functions on your data (such as SUM, filtering, VLOOKUP, etc.) becomes tricky with the merged cells.