Send to a Friend

elbanditoroso's avatar

Can you assist with an Excel output question?

Asked by elbanditoroso (33158points) February 23rd, 2018

Need your wisdom. I have looked at all sorts of Excel reporting templates, but they don’t seem to do what I want.

Situation:
I have an excel spreadsheet with 9 columns. Columns are A through I. All text, no numbers. I’m using this to store descriptive information about particular products.

What I want to do is the following: create a report that outputs the data vertically, as shown below:

Contents of Column A1
Contents of Column B1
and so on
Contents of Column I1
<space between>
Contents of Column A2
Contents of Column B2
and so on
Contents of Column I2
<space between>

and on and on.

Is there some simple way to make this sort of output?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.