Use pastespecial and transpose or try below link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=144
On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar wrote:
> I have a series of spreadsheets that have data in them that needs to
> be formatted into 3 columns instead of one column.
>
> The data in
Should do it assuming layout as described
-Original Message-
From: GreenBriar
Sent: Thursday, August 25, 2011 10:55 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns
I have a series of spreadsheets that have data in them that needs to
Dear green
go through the attachment. it may help.
--
*Great day,*
*viper*
On Fri, Aug 26, 2011 at 10:42 AM, NOORAIN ANSARI
wrote:
> Please provide sample sheet.
>
>
> On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar
> wrote:
>
>> I have a series of spreadsheets that have data in them that
Please provide sample sheet.
On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar wrote:
> I have a series of spreadsheets that have data in them that needs to
> be formatted into 3 columns instead of one column.
>
> The data in Row 1 needs to go in row 1, column 1
> Row 2 needs to go in row 1, column 2
>
I have a series of spreadsheets that have data in them that needs to
be formatted into 3 columns instead of one column.
The data in Row 1 needs to go in row 1, column 1
Row 2 needs to go in row 1, column 2
Row 3 = Row 1, Col 3
Row 4 = Row 2, Col 1
Row 5 = Row 2, Col 2
Row 6 = Row 2 Col 3
Row 7 = R
