Moving Data

[benn]

Could any help on how to transpose 5 or 6 rows in one colum of data into 1 row of data, Ok that is the easy bit, I have that much data that I was wondering if I could Automate or set up some kind of template to do this as I paste the data into the program. The program the data is coming from does not allow me to export I have to manually cut and past.


ThanKyou

[Dave Peterson]

Does this mean that the data is always on 5 rows on one file (and maybe 6 rows
on another)?

Or does this mean that within one worksheet, the data is sometimes 5 rows and
sometimes 6 rows?

And is there a way to determine that grouping--maybe a blank row between
groups???



benn wrote:
>
> Could any help on how to transpose 5 or 6 rows in one colum of data into
> 1 row of data, Ok that is the easy bit, I have that much data that I was
> wondering if I could Automate or set up some kind of template to do this
> as I paste the data into the program. The program the data is coming
> from does not allow me to export I have to manually cut and past.
>
> ThanKyou
>
> --
> benn
> ------------------------------------------------------------------------
> benn's Profile: http://www.excelforum.com/member.php...o&userid=29387
> View this thread: http://www.excelforum.com/showthread...hreadid=490984

--

Dave Peterson