Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[ashish koul]

=OFFSET('Sample - Unedited'!$A$1,COLUMN('Sample -
Edited'!A1)+(COUNTA($A$1:$C$1)*(ROW(A1)-1)),0)

'Sample - Unedited'!$A$1 - header of source column

COLUMN('Sample - Edited'!A1) - will give us 1 , 2 , 3

(COUNTA($A$1:$C$1)*(ROW(A1)-1)) will give us 0 , 3, 6

'
0  because source data is in same column


to know more about offset visit
http://www.techonthenet.com/excel/formulas/offset.php

if you require  any further info please feel free to ask in the group















On Tue, Aug 20, 2013 at 10:30 AM, Chaya Cooper wrote:

> Ashish,
>
> That's exactly what I needed :-D
>
> Would you mind showing me how to use it?
>
> - Chaya
>
>
> On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
>
>> Hi try the attachment .  see if it helps
>>
>>
>>
>>
>> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote:
>>
>>> Hi Chaya, Prabhu,
>>>
>>> Done with a simple macro.
>>>
>>> Use Control + Shift + A at particular cell where you want to transpose.
>>>
>>> This you have to to for every entry.
>>>
>>> In case you want it for mulitiple entries there shall be different macro
>>> required.
>>>
>>> While running this macro, Check your macro security setting. I guess it
>>> it is "High to Very high" Change it to Medium.
>>>
>>> Regards
>>> Prashant
>>>
>>>
>>> On Tue, Aug 20, 2013 at 6:
>>> 15 AM, Chaya Cooper  wrote:
>>>
 Thanks for clarifying :-)

 Here's a sample file with 2 sheets, one with the original (unedited)
 data, and one with the data in the correct format :-)

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/**discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros...@**googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.

 Visit this group at 
 http://groups.google.com/**group/excel-macros
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_out
 .

>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *My Excel Blog *
>> Like Us on 
>> Facebook
>> Join Us on Facebook 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Fa

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Prashant Pednekar]

Dear Chaya

The solution from Ashish (using offset command)  has lesser effort than
using macro. I suggest to use the same for your multiple entries.

using macro is possible in 2008 . no issue. For your information. you have
to use Ctrl+ shift + A at first column of each row required.

Regards
Prashant.



On Tue, Aug 20, 2013 at 10:30 AM, Chaya Cooper wrote:

> Ashish,
>
> That's exactly what I needed :-D
>
> Would you mind showing me how to use it?
>
> - Chaya
>
>
> On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
>
>> Hi try the attachment .  see if it helps
>>
>>
>>
>>
>> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote:
>>
>>> Hi Chaya, Prabhu,
>>>
>>> Done with a simple macro.
>>>
>>> Use Control + Shift + A at particular cell where you want to transpose.
>>>
>>> This you have to to for every entry.
>>>
>>> In case you want it for mulitiple entries there shall be different macro
>>> required.
>>>
>>> While running this macro, Check your macro security setting. I guess it
>>> it is "High to Very high" Change it to Medium.
>>>
>>> Regards
>>> Prashant
>>>
>>>
>>> On Tue, Aug 20, 2013 at 6:
>>> 15 AM, Chaya Cooper  wrote:
>>>
 Thanks for clarifying :-)

 Here's a sample file with 2 sheets, one with the original (unedited)
 data, and one with the data in the correct format :-)

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/**discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros...@**googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.

 Visit this group at 
 http://groups.google.com/**group/excel-macros
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_out
 .

>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *My Excel Blog *
>> Like Us on 
>> Facebook
>> Join Us on Facebook 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, 

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Chaya Cooper]

Ashish,

That's exactly what I needed :-D

Would you mind showing me how to use it?

- Chaya

On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
>
> Hi try the attachment .  see if it helps
>
>
>
>
> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar 
> 
> > wrote:
>
>> Hi Chaya, Prabhu,
>>
>> Done with a simple macro.
>>
>> Use Control + Shift + A at particular cell where you want to transpose.
>>
>> This you have to to for every entry.
>>
>> In case you want it for mulitiple entries there shall be different macro 
>> required. 
>>
>> While running this macro, Check your macro security setting. I guess it 
>> it is "High to Very high" Change it to Medium.
>>
>> Regards 
>> Prashant 
>>
>>
>> On Tue, Aug 20, 2013 at 6:
>> 15 AM, Chaya Cooper > wrote:
>>
>>> Thanks for clarifying :-)
>>>
>>> Here's a sample file with 2 sheets, one with the original (unedited) 
>>> data, and one with the data in the correct format :-)
>>>  
>>> -- 
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>  
>>> FORUM RULES
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>  
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>>> members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to excel-macros...@googlegroups.com .
>>> To post to this group, send email to excel-...@googlegroups.com
>>> .
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>  -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> -- 
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>  
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroup

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Chaya Cooper]

Hi Prashant,

I've only used macros a few times, and am having trouble a wee bit of 
trouble figuring things out because I'm temporarily using a Excel 2008 for 
Mac :-( (I'm normally a PC gal, with Office 2007 ;-))
 
Can I trouble you to explain when I should use Control + Shift + A, and how 
to open and use this macro? 

Also, am I correct in assuming that by 'multiple entries' you meant 
multiple rows? If so, would you mind clarifying how to do it with different 
macros? I'm using this for several hundred rows (once it is formatted 
correctly), so I'm assuming that I'll probably need to do this :-)

On Tuesday, August 20, 2013 12:16:50 AM UTC-4, prashant wrote:
>
> Hi Chaya, Prabhu,
>
> Done with a simple macro.
>
> Use Control + Shift + A at particular cell where you want to transpose.
>
> This you have to to for every entry.
>
> In case you want it for mulitiple entries there shall be different macro 
> required. 
>
> While running this macro, Check your macro security setting. I guess it it 
> is "High to Very high" Change it to Medium.
>
> Regards 
> Prashant 
>
>
> On Tue, Aug 20, 2013 at 6:
> 15 AM, Chaya Cooper > wrote:
>
>> Thanks for clarifying :-)
>>
>> Here's a sample file with 2 sheets, one with the original (unedited) 
>> data, and one with the data in the correct format :-)
>>  
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[ashish koul]

Hi try the attachment .  see if it helps




On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote:

> Hi Chaya, Prabhu,
>
> Done with a simple macro.
>
> Use Control + Shift + A at particular cell where you want to transpose.
>
> This you have to to for every entry.
>
> In case you want it for mulitiple entries there shall be different macro
> required.
>
> While running this macro, Check your macro security setting. I guess it it
> is "High to Very high" Change it to Medium.
>
> Regards
> Prashant
>
>
> On Tue, Aug 20, 2013 at 6:
> 15 AM, Chaya Cooper  wrote:
>
>> Thanks for clarifying :-)
>>
>> Here's a sample file with 2 sheets, one with the original (unedited)
>> data, and one with the data in the correct format :-)
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Sample File.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Prabhu Pinky]

Am just asking you to share the excel file.
On 20-Aug-2013 5:50 AM, "Chaya Cooper"  wrote:

> I'm sorry, I'm not sure I understand what you're saying :-(
>
> On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>>
>> hi chaya,
>>
>> hope if u share the file.. it will be so fine to work.
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>>
>> On 20 August 2013 04:35, Chaya Cooper  wrote:
>>
>>> Unfortunately, the data in each row is different
>>>
>>> I've attached an image with an example :-)
>>>
>>>
>>> On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky wrote:
>>>
 you mean same data in each row..?.. or can you share me your file with
 requirement..?

 like below..

 [image: Inline images 1]


 Thanks & Regards,
 Prabhu R


 On 20 August 2013 04:02, Chaya Cooper  wrote:

> That's amazing :-D I'm sorry I waited this long to ask ;-)
>
> One question - is there a way to split it up into several rows (for
> example 5 rows, with 3 columns per row)?
>
> On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>
>> Hi Chaya,
>>
>> You no need to cut and paste the each cells. Simply u just copy the
>> data which u need to be in row. then right click->paste special->values
>> (and select transpose). Now you data will be pasted in single row.
>>
>> Note the same method u can use to copy the data in single column if
>> it is in single row.
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>>
>> On 20 August 2013 02:55, Chaya Cooper  wrote:
>>
>>>
>>>
>>> I often have to move cells in order to have them in a row (going
>>> across) instead of in a column (going down). Is there a way to simplify
>>> this so that I don't have to manually cut & paste or move each cell?
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discu**ssexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros...@**googlegroups.**com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group**/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**grou**ps/opt_out
>>> .
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/**discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@**googlegroups.com.
>
> To post to this group, send email to excel-...@googlegroups.com.
> Visit this group at 
> http://groups.google.com/**group/excel-macros
> .
> For more options, visit 
> https://groups.google.com/**groups/opt_out

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Chaya Cooper]

I'm sorry, I'm not sure I understand what you're saying :-(

On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>
> hi chaya,
>
> hope if u share the file.. it will be so fine to work.
>
>
> Thanks & Regards,
> Prabhu R
>
>
> On 20 August 2013 04:35, Chaya Cooper >wrote:
>
>> Unfortunately, the data in each row is different 
>>
>> I've attached an image with an example :-)
>>
>>
>> On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky 
>> 
>> > wrote:
>>
>>> you mean same data in each row..?.. or can you share me your file with 
>>> requirement..?
>>>
>>> like below..
>>>
>>> [image: Inline images 1]
>>>
>>>
>>> Thanks & Regards,
>>> Prabhu R
>>>
>>>
>>> On 20 August 2013 04:02, Chaya Cooper >> >wrote:
>>>
 That's amazing :-D I'm sorry I waited this long to ask ;-)

 One question - is there a way to split it up into several rows (for 
 example 5 rows, with 3 columns per row)?

 On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:

> Hi Chaya,
>
> You no need to cut and paste the each cells. Simply u just copy the 
> data which u need to be in row. then right click->paste special->values 
> (and select transpose). Now you data will be pasted in single row.
>
> Note the same method u can use to copy the data in single column if it 
> is in single row.
>
>
> Thanks & Regards,
> Prabhu R
>
>
> On 20 August 2013 02:55, Chaya Cooper  wrote:
>
>>  
>>
>> I often have to move cells in order to have them in a row (going 
>> across) instead of in a column (going down). Is there a way to simplify 
>> this so that I don't have to manually cut & paste or move each cell? 
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/**discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like 
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need 
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>> and members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google 
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, 
>> send an email to excel-macros...@**googlegroups.com.
>> To post to this group, send email to excel-...@googlegroups.com.
>>
>> Visit this group at 
>> http://groups.google.com/**group/excel-macros
>> .
>> For more options, visit 
>> https://groups.google.com/**groups/opt_out
>> .
>>
>
>  -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com .

 To post to this group, send email to 
 excel-...@googlegroups.com
 .
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

>>>
>>>  -- 
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>  
>>> FORUM RULES
>>>  
>>> 1) Use concise, accurate thread titles. P

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Prabhu Pinky]

hi chaya,

hope if u share the file.. it will be so fine to work.


Thanks & Regards,
Prabhu R


On 20 August 2013 04:35, Chaya Cooper  wrote:

> Unfortunately, the data in each row is different
>
> I've attached an image with an example :-)
>
>
> On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky wrote:
>
>> you mean same data in each row..?.. or can you share me your file with
>> requirement..?
>>
>> like below..
>>
>> [image: Inline images 1]
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>>
>> On 20 August 2013 04:02, Chaya Cooper  wrote:
>>
>>> That's amazing :-D I'm sorry I waited this long to ask ;-)
>>>
>>> One question - is there a way to split it up into several rows (for
>>> example 5 rows, with 3 columns per row)?
>>>
>>> On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>>>
 Hi Chaya,

 You no need to cut and paste the each cells. Simply u just copy the
 data which u need to be in row. then right click->paste special->values
 (and select transpose). Now you data will be pasted in single row.

 Note the same method u can use to copy the data in single column if it
 is in single row.


 Thanks & Regards,
 Prabhu R


 On 20 August 2013 02:55, Chaya Cooper  wrote:

>
>
> I often have to move cells in order to have them in a row (going
> across) instead of in a column (going down). Is there a way to simplify
> this so that I don't have to manually cut & paste or move each cell?
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/**discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@**googlegroups.com.
> To post to this group, send email to excel-...@googlegroups.com.
>
> Visit this group at 
> http://groups.google.com/**group/excel-macros
> .
> For more options, visit 
> https://groups.google.com/**groups/opt_out
> .
>

  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the r

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Prabhu Pinky]

you mean same data in each row..?.. or can you share me your file with
requirement..?

like below..

[image: Inline images 1]


Thanks & Regards,
Prabhu R


On 20 August 2013 04:02, Chaya Cooper  wrote:

> That's amazing :-D I'm sorry I waited this long to ask ;-)
>
> One question - is there a way to split it up into several rows (for
> example 5 rows, with 3 columns per row)?
>
> On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>
>> Hi Chaya,
>>
>> You no need to cut and paste the each cells. Simply u just copy the data
>> which u need to be in row. then right click->paste special->values (and
>> select transpose). Now you data will be pasted in single row.
>>
>> Note the same method u can use to copy the data in single column if it is
>> in single row.
>>
>>
>> Thanks & Regards,
>> Prabhu R
>>
>>
>> On 20 August 2013 02:55, Chaya Cooper  wrote:
>>
>>>
>>>
>>> I often have to move cells in order to have them in a row (going across)
>>> instead of in a column (going down). Is there a way to simplify this so
>>> that I don't have to manually cut & paste or move each cell?
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Chaya Cooper]

That's amazing :-D I'm sorry I waited this long to ask ;-)

One question - is there a way to split it up into several rows (for example 
5 rows, with 3 columns per row)?

On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>
> Hi Chaya,
>
> You no need to cut and paste the each cells. Simply u just copy the data 
> which u need to be in row. then right click->paste special->values (and 
> select transpose). Now you data will be pasted in single row.
>
> Note the same method u can use to copy the data in single column if it is 
> in single row.
>
>
> Thanks & Regards,
> Prabhu R
>
>
> On 20 August 2013 02:55, Chaya Cooper >wrote:
>
>>
>>
>> I often have to move cells in order to have them in a row (going across) 
>> instead of in a column (going down). Is there a way to simplify this so 
>> that I don't have to manually cut & paste or move each cell? 
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

[Prabhu Pinky]

Hi Chaya,

You no need to cut and paste the each cells. Simply u just copy the data
which u need to be in row. then right click->paste special->values (and
select transpose). Now you data will be pasted in single row.

Note the same method u can use to copy the data in single column if it is
in single row.


Thanks & Regards,
Prabhu R


On 20 August 2013 02:55, Chaya Cooper  wrote:

>
>
> I often have to move cells in order to have them in a row (going across)
> instead of in a column (going down). Is there a way to simplify this so
> that I don't have to manually cut & paste or move each cell?
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ How can I change selected cells from a column into a row?

[Chaya Cooper]

I often have to move cells in order to have them in a row (going across) 
instead of in a column (going down). Is there a way to simplify this so 
that I don't have to manually cut & paste or move each cell? 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.