Creating a report from Excel Table

[petersw]

Hi,

I've got a table with a lot of text in it, and I'd like to be able to print it out in a report format. For example:

Name	Notes1	Notes2
JohnSmith	Likes to eat apples	Never drives at night
TomJones	Likes to eat oranges	Wife's name is Velma

<tbody>
</tbody>

From this, I'd like to create a text report as follows:

JohnSmith

Notes1: Likes to eat apples
Notes2: Never drives at night
​

TomJones

Notes1: Likes to eat oranges
Notes2: Wife's name is Velma
​

Is is possible to do this? Thanks in advance!!

p.s. I think Excel is the wrong place to keep notes like this, but I don't have control over the content in this case...

 

[Joyner]

Hello, there would be several ways to do this, vba probably being a good solution, or using another column using formulas.

Another really simple option would be to use a Pivot Table and you can easily change the format/report. The only thing, the " Note1:" and Note2:" will not show unless you concatenate them into the actual data, but again that would be simple.

To use a pivot table, simple click in your data, Insert Tab, click PivotTable, and in the Row area, put the Name, and then Note1, then Note2. You can use various report formats, remove the "-" collapse buttons, rename the heading etc.