I have exported info from a program at work to an excel spreadsheet. This
spreadsheet does not come out in the format I am looking for. This
spreadsheet lists info from one entry in multiple rows. I'm looking to have
all this info from one entry in multiple columns not rows. Is there a way to
export the data from the excel spreadsheet to another excel spreadsheet in
the format I am looking for?

CopyPaste SpecialTransposeOKEsc


Gord Dibben MS Excel MVP


On Wed, 21 Oct 2009 06:41:01 -0700, TB@work
wrote:

I have exported info from a program at work to an excel spreadsheet. This
spreadsheet does not come out in the format I am looking for. This
spreadsheet lists info from one entry in multiple rows. I'm looking to have
all this info from one entry in multiple columns not rows. Is there a way to
export the data from the excel spreadsheet to another excel spreadsheet in
the format I am looking for?

The difficulty of this would depend upon how the information comes out. Is
every record, say, 5 rows?

If so, the formula would be simple...

in cell A2 of a new sheet: =Sheet1!A2
in cell B2 =Sheet1!A3
and so on across the row.

Then, copy rows 2 through 6 (3 - 6 being blank) and paste down your sheet.

If the records are not all of the same length, you'd need some sort of
unique identifier for each new record...

"TB@work" wrote:

I have exported info from a program at work to an excel spreadsheet. This
spreadsheet does not come out in the format I am looking for. This
spreadsheet lists info from one entry in multiple rows. I'm looking to have
all this info from one entry in multiple columns not rows. Is there a way to
export the data from the excel spreadsheet to another excel spreadsheet in
the format I am looking for?