Re: $$Excel-Macros$$ Transpose data

Hi Vaibhav, Macro sheet or Formula sheet both are working fine. Great work bro...!!! Regards Ashish -- 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 RUL

Re: $$Excel-Macros$$ Transpose data

Cheers. On Aug 31, 2014 1:41 PM, "Rupesh Patil" wrote: > Hi Vaibhav, > > Very very thanks, > it is working as expected. > > > Thanks and regards > Rupesh > > > On Sun, Aug 31, 2014 at 12:44 PM, Vaibhav Joshi wrote: > >> Cheers Bro.. >> >> Check this it has macro, i assume if lines are in millio

Re: $$Excel-Macros$$ Transpose data

Hi Vaibhav, Very very thanks, it is working as expected. Thanks and regards Rupesh On Sun, Aug 31, 2014 at 12:44 PM, Vaibhav Joshi wrote: > Cheers Bro.. > > Check this it has macro, i assume if lines are in millions than formula > will get slower.. > > Click run macro, select input sheet ha

Re: $$Excel-Macros$$ Transpose data

Cheers Bro.. Check this it has macro, i assume if lines are in millions than formula will get slower.. Click run macro, select input sheet having data, select output sheet & done.. Cheers!! On Sun, Aug 31, 2014 at 10:29 AM, Ashish Kumar wrote: > Hi Vaibhav, > > Bro its superb solution. > > >

Re: $$Excel-Macros$$ Transpose data

Hi Vaibhav, Bro its superb solution. Regards Ashish -- 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

Re: $$Excel-Macros$$ Transpose data

August 30, 2014 3:08 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Transpose data >> >> >> >> Dear Expert, >> >> >> >> I need one micro or formula which transpose data. >> >> >> >> Sampl

Re: $$Excel-Macros$$ Transpose data

> excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Saturday, August 30, 2014 3:08 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Transpose data > > > > Dear Expert, > > > > I need one micro or formula which transpose data. &g

RE: $$Excel-Macros$$ Transpose data

What kind of output you want….! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Saturday, August 30, 2014 3:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Transpose data Dear Expert, I need one micro or

$$Excel-Macros$$ Transpose data

Dear Expert, I need one micro or formula which transpose data. Sample file attach with mail with explanation. please help me out Thanks and regards Rupesh -- 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 fo

Re: $$Excel-Macros$$ Transpose Data from cell to columns

Thnx to all for this great help..! Kaяan

Re: $$Excel-Macros$$ Transpose Data from cell to columns

Dear karan, By Excel Use formula *=SUBSTITUTE(A1,CHAR(10),"-") * in second Column, and Copy and Paste it as value, then normal you can use Text to column . On Tue, Sep 13, 2011 at 5:02 PM, karan 1237 wrote: > Dear Noorain thanks for replying, but still my query has not solv

Re: $$Excel-Macros$$ Transpose Data from cell to columns

ther:=True, OtherChar:="" & Chr(10) Cells.EntireColumn.AutoFit Cells.EntireRow.AutoFit End Sub From: karan 1237 Sent: Tuesday, September 13, 2011 4:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Transpose Data from cell to columns Dear All, I'v to transpose data f

Re: $$Excel-Macros$$ Transpose Data from cell to columns

Select the data u want to transpose copy it...then right ckick to another location then select paste special from the list..check on transpose box & click ok. On Tue, Sep 13, 2011 at 2:35 PM, karan 1237 wrote: > Dear All, > > I'v to transpose data from a cell to columns. Please solve my quer

Re: $$Excel-Macros$$ Transpose Data from cell to columns

Copy the Texts from the Formula Bar. This will copy as individual data's, paste this on empty cells. Paste special Transpose. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

Re: $$Excel-Macros$$ Transpose Data from cell to columns

Dear Noorain thanks for replying, but still my query has not solved. I want to transpose data from cell to columns, I don't want to do Text to columns. Please see attached file. Kaяan

$$Excel-Macros$$ Transpose Data from cell to columns

Dear All, I'v to transpose data from a cell to columns. Please solve my query. Thnx in advance Kaяan

Re: $$Excel-Macros$$ Transpose Data by Formula

STDEV(i), Excellent! Works like a charm. If I would like to add a formula to the total column, that would only pick up only the Order Qty amount, how would I do that? (the order number is a six digit number and adds to the total) I would use =SUMIF(A$25:Z$25,"Order Qty",A26:Z26) after the fact,

Re: $$Excel-Macros$$ Transpose Data by Formula

Dear Mr. Smith, Please try and check this VBA Code, if it helps... Sub AbnormalizeYourTabel() ' STDEV(i) / milis belajar-excel / 08 apr 2011 ' retouched for another table-structure ' jakarta, Jun 12, 2011 '--- Dim Tbl As Range, NewTbl A

$$Excel-Macros$$ Transpose Data by Formula

Please, attached is an example of data which I need to transpose and a pivot table doesn't do it... Thank you for your help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks a