I have a workbook in which I have almost 150 sheet. In each sheet I have data in column like in range A1:AX1. I want to transpose that data in rows in same sheet. Just to say in each sheet the range is not fix. I want to develop a maro which will transpose my data from columns to rows for all the 150 sheets data.
PLease see the data I have in sheet as example
Sheet 1: Here I want the
sheet 2 :-
PLease see the data I have in sheet as example
Sheet 1: Here I want the
sheet 2 :-