Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Sheets("Output").Range("f" & k) = Cells(i, j).Text > Sheets("Output").Range("e" & k) = Cells(1, s) > Sheets("Output").Range("g" & k) = Cells(i, s).Text > k = k + 1 >

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Hi, My apologies, i uploaded the wrong work book second time around. Attached is the actual book.* (File Name: Request.xlsx)* On Tuesday, 28 January 2014 00:26:27 UTC+5:30, bé trần văn wrote: > > You see File, with PivotTable VBA. > > 2014-01-27 Umesh Kumar > > >> Hi Ashi

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

Hi Ashish, I had pasted the sample file. Will attache it again. On Saturday, 25 January 2014 12:52:29 UTC+5:30, ashish wrote: > > please share sample file > > > On Fri, Jan 24, 2014 at 2:13 PM, Umesh Kumar > > wrote: > >> I would need help in converting table which

$$Excel-Macros$$ Need help in converting table format data to pivot format in excel

I would need help in converting table which is in table format to a pivot format. Below is the sample data which i have: