Dear Amit,
If you want to just convert data into vertical form. Follow these
steps:
-Copy your data using Ctrl+C
-Choose the cell where you want to paste your data
-Go to the Edit Menu and choose "Paste Special"
-In the paste special dialog box choose "All" and click the
"Transpose" option...and
Hi Sam
solution provided by chilexcel is OK, but i want to go further in full
automation using excel formulas.
Thanks
Amit
On Mon, Sep 26, 2011 at 11:49 AM, Sam Mathai Chacko wrote:
> Nicely done by Noorain.
>
> Shouldn't the solution provided by ChilExcel suffice? Pivot tables as it is
> dyn
thanks Noorain.
On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI
wrote:
> Dear Amit,
>
> Please see attached sheet..
>
> and use
> *
> =INDEX($B$4:$B$150,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3)
> =Offset($B$4,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3,0)*
>
> --
> Than
Nicely done by Noorain.
Shouldn't the solution provided by ChilExcel suffice? Pivot tables as it is
dynamic in nature, you just need to pass the source range.
Regards,
Sam Mathai Chacko (GL)
On Mon, Sep 26, 2011 at 11:40 AM, NOORAIN ANSARI
wrote:
> Dear Amit,
>
> Please see attached sheet..
>