If you want to apply a minor tweak to the document, it must not require much time to Turn on columns form. This kind of basic action does not have to demand extra training or running through guides to understand it. Using the proper document modifying resource, you will not spend more time than is necessary for such a quick change. Use DocHub to simplify your modifying process whether you are a skilled user or if it’s the first time using an online editor service. This tool will require minutes to learn to Turn on columns form. The sole thing required to get more productive with editing is a DocHub profile.
A plain document editor like DocHub can help you optimize the time you need to spend on document modifying irrespective of your previous experience with such instruments. Create an account now and boost your efficiency instantly with DocHub!
hi welcome to excel laptop watching well see transpose function an inbuilt function in Excel and well see how it functions so now here the data is the date and the DS are give 1 ok so starting with 17 December and the day is Monday so what I want this JND to be you know horizontally pleased okay so so what I will do to to convert this vertical or column into you know the horizontal row first I will I will select the cells okay so these are seven dates so first I will select the seven cells and then get it selected only and then then put equal to and right transpose so here you can see transpose function and what it tells that it converts a vertical range of cells to a horizontal range or Y suppose also you click on this and then it is showing that array okay now remember it is an array not not the simple range so so for an array always remember the comma on which is control shift and enter so you first select the range close the bracket and then control shift enter so we got it now