https://community.qlik.com/t5/Connectivity-Data-Prep/data-in-order/m-p/1538279#M7442 <P>I have a Excel source file,in that excel source file there were multiple sheets in each sheet the data is at centre of sheet.So,while loading the file into the QlikView how will you arrrange the data in order?</P> Thu, 23 Dec 2021 20:14:15 GMT sonysree88 2021-12-23T20:14:15Z https://community.qlik.com/t5/Connectivity-Data-Prep/data-in-order/m-p/1538279#M7442 <P>I have a Excel source file,in that excel source file there were multiple sheets in each sheet the data is at centre of sheet.So,while loading the file into the QlikView how will you arrrange the data in order?</P> Thu, 23 Dec 2021 20:14:15 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/data-in-order/m-p/1538279#M7442 sonysree88 2021-12-23T20:14:15Z https://community.qlik.com/t5/Connectivity-Data-Prep/data-in-order/m-p/1538306#M7443 Have a look at the transformation wizard<BR /><BR /><A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/File_Wizard_Transform.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/File_Wizard_Transform.htm</A><BR /><BR /><A href="https://community.qlik.com/t5/New-to-QlikView/where-is-File-Wizard-Transform/td-p/1038195" target="_blank">https://community.qlik.com/t5/New-to-QlikView/where-is-File-Wizard-Transform/td-p/1038195</A> Fri, 01 Feb 2019 09:36:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/data-in-order/m-p/1538306#M7443 pradosh_thakur 2019-02-01T09:36:06Z