Slow process

Hello there,

I've encountered a process as to which I need to sort and arrange things using an excel document to make a program for a machine.

Unfortunately, the way I do it is long winded and slow, I was wondering if there is another way to do it.

The way I do it is spread the numbers out in column D by inserting new rows, and typing all the numbers which takes a long time, in a column, like the example at the bottom of this screenshot.

Then I highlight and drag the other cells so that the circuit ref matches the PN's involved.

Problem.png

Any help would be appreciated, thanks.

So, you want to split the entries which are in column D so that each entry appears on a different row?

It would help if you attached a sample Excel workbook, as I do not fancy typing your data in before I can make a start.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work on this forum, so don't bother trying it that way.

Hope this helps.

Pete

Thanks for the information Pete, about uploading the file, I have a test model uploaded now.

The answer for column D is it is split into 24 rows unfortunately, if there is a way to do that.

sorry for the long reply, been rather busy with other things at work.

I'm aiming to split the entries into separate rows on the same sheet, but if that can't be done, a different sheet will be brilliant as well.

Thanks again

Here's how I read your problem.

Please Login or Register  to view this content.

That works wonders, thanks alot

That's brilliant, thanks very much

I found the problem, thanks for the help, the problem was is we use sensors, and they are labeled as SENSEA-SENSEC the A-C is what it didn't like I think.

It also didn't like another thing in the document, which was GND1A-GND1H which isn't a commonly used thing for us, but it's on a few things here, is there any way to make it work around those, or include them in any way?

That works wonders, thank you very much!