When you edit documents in different formats every day, the universality of the document solution matters a lot. If your tools work with only some of the popular formats, you might find yourself switching between software windows to correct comma in spreadsheet and handle other file formats. If you want to remove the headache of document editing, go for a platform that will effortlessly handle any format.
With DocHub, you do not need to concentrate on anything but actual document editing. You won’t have to juggle applications to work with various formats. It can help you revise your spreadsheet as effortlessly as any other format. Create spreadsheet documents, modify, and share them in one online editing platform that saves you time and improves your productivity. All you need to do is register a free account at DocHub, which takes only a few minutes.
You won’t have to become an editing multitasker with DocHub. Its feature set is sufficient for fast document editing, regardless of the format you need to revise. Start by creating a free account to see how straightforward document management may be having a tool designed specifically to meet your needs.
hi this vid Ill show you how to split comma-separated values or other delimited data into separate roles so what does that mean lets say we have this is a simple two column table and we see our other column here has items that are separated by commas here and what we want to do so this is the same table but its not just color-coded here just got some colors and what we want to do is we want to take those items that are separated by commas and break them out into their own rows so you can see here theres four values here in this column item 14 17 15 8 and 8 for invoice number 1 0 1 1 so we can see what we have our invoice number 1 0 1 1 these four separate rows form and we have 4 separate rows for those item numbers 14 17 15 and 8 alright so theyre all separated instead of commas in their own rows and its the same here what invoice 15:47 weve got our range of items that were originally separated by commas in its own row in its own row so how can we do that well we can do that wi