You know you are using the proper file editor when such a simple task as Separate line record does not take more time than it should. Editing papers is now a part of many working processes in numerous professional areas, which is the reason accessibility and efficiency are crucial for editing resources. If you find yourself researching manuals or trying to find tips on how to Separate line record, you might want to find a more user-friendly solution to save your time on theoretical learning. And here is where DocHub shines. No training is needed. Just open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Take advantage of this tool to complete the files you need in short time and take your productivity to a higher level!
hi in this video im going to show you how to split multiple line or multi-line records into separate rows so what does that mean lets say for example we have a table like this and basically this is almost like a attribute value pair see we have our we have our attributes or our fields region west date and a date actually the date is in serial number format well change that later on invoice and then the invoice amount subtotal subtotal total total amount we dont want to look like that sometimes we get data like this we want to look like this into a table where we can do some further analysis so you see the header fields they are kind of proper header names and in the subsequent rows these are the values of all those headers so were going to use power query to see how this done now here im in excel and i have my attribute value pairs this is basically this is my multi-line records and i want to transform this its almost like taking this range of data and doing a pivot on it but w