Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-02-01 Thread pesh
Dear Anil, Thank you again for your efforts. It seems however that as I run the program, that in cases where there is less that 5 within a category, the transpose then erroneously pastes the figures. For example, if I were to move the last data set of 1,2,5 to the first and move all else belo

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-02-01 Thread pesh
Dear Anil, Please accept my apologies. I had made an error on my part in accidentally having deleted a letter from the file you provided. As a matter of fact, your solution works great. Thank you very much for all of your efforts on this. I sincerely appreciate it. Best regards and wishing you

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-31 Thread Prince
Hi Aplesh PFA Regards Prince On Thursday, January 31, 2013 6:50:02 PM UTC+5:30, pesh wrote: > > Dear Anil, > > Thank you for your response. However, I have not received the file you > refer to. Only I see the sample file I had submitted originally. > Could you please resend? > > Thank you. > Al

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-31 Thread Alpesh Shah
Dear Anil, Thank you for your response. However, I have not received the file you refer to. Only I see the sample file I had submitted originally. Could you please resend? Thank you. Alpesh On Thu, Jan 31, 2013 at 2:25 AM, अनिल नारायण गवली wrote: > Dear Alpeshah, > > Pl find attached Sheet for

$$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-30 Thread Alpesh Shah
Dear Excel Masters, I have raw data that is in the following form: 1 name abc 2 address 234 john lane 3 company inc, co 4 website http://website.com 5 description company abc is abc What I would like to do is have this information look like this, where the data is taken from rows and transpos