Hi, I am new to the board, and an Excel neophyte.
I've just been assigned the task at work of re-doing a spreadsheet so that multiple sets of number codes contained within a single cell can be placed on multiple rows. The spreadsheet was sent to us from another company. But we have to place the number codes (from columns A and M) into our own spreadsheet into single multiple rows. I've been doing this manually (copy/paste) for two days, but thought there just has to be an easier way. I have to do this for 9 workbooks.
The spreadsheets are in Excel 2010.
The first workbook I'm working on has 298 rows of data.
Rows 1 to 8 contain a header. Row 9 contains the column titles and is frozen from scrolling.
The data I need to split or separate are from columns A and M only. They occur always on the same row (there is other data in columns B through L which needs to be kept on the same rows when split, but can just be repeated).
Not every cell in columns A and M contains multiple lines of number codes that I need to split. But many do, and they are random. And when they occur, they always are on the same row in both column A and column M. Sometimes the amount of lines from column A and M don't match, but this is an error from the company who sent them to us.
Example:
Column A, (row 12)
QT01176-I-GIO-B-PFD-003/
QT01176-I-GIO-B-PFD-004/
QT01176-I-GIO-B-PFD-005/
QT01176-I-GIO-B-PFD-006/
QT01176-I-GIO-B-PFD-007/
QT01176-I-GIO-B-PFD-008/
QT01176-I-GIO-B-PFD-009
Column M (row 12)
MCF-1-942-00-1598-01
MCF-1-942-00-1599-01
MCF-1-942-00-1600-01
MCF-1-942-00-1601-01
MCF-1-942-00-1602-01
MCF-1-942-00-1603-01
MCF-1-942-00-1604-01
A17
BIC01176-I-GIO-DR-01
BIC01176-I-GIO-DR-02
BIC01176-I-GIO-DR-03
BIC01176-I-GIO-DR-04
BIC01176-I-GIO-DR-05
BIC01176-I-GIO-DR-06
BIC01176-I-GIO-DR-07
M17
MCF-1-951-00-0722-01
MCF-1-951-00-0723-01
MCF-1-951-00-0724-01
MCF-1-951-00-0725-01
MCF-1-951-00-0726-01
MCF-1-951-00-0727-01
MCF-1-951-00-0728-01
A30
QT01176-I-GIO-G-DR-021/
QT01176-I-GIO-G-DR-022/
QT01176-I-GIO-G-DR-023/
QT01176-I-GIO-G-DR-024/
QT01176-I-GIO-G-DR-025/
QT01176-I-GIO-G-DR-026/
QT01176-I-GIO-G-DR-027/
QT01176-I-GIO-G-DR-028/
QT01176-I-GIO-G-DR-029/
QT01176-I-GIO-G-DR-030/
QT01176-I-GIO-G-DR-031/
QT01176-I-GIO-G-DR-032/
QT01176-I-GIO-G-DR-033/
QT01176-I-GIO-G-DR-034/
QT01176-I-GIO-G-DR-035/
QT01176-I-GIO-G-DR-036/
QT01176-I-GIO-G-DR-037/
QT01176-I-GIO-G-DR-038/
QT01176-I-GIO-G-DR-039/
QT01176-I-GIO-G-DR-040/
QT01176-I-GIO-G-DR-041/
QT01176-I-GIO-G-DR-042/
QT01176-I-GIO-G-DR-043/
QT01176-I-GIO-G-DR-044/
QT01176-I-GIO-G-DR-045/
QT01176-I-GIO-G-DR-046/
QT01176-I-GIO-G-DR-047/
QT01176-I-GIO-G-DR-048/
QT01176-I-GIO-G-DR-049
M30
MCF-1-977-00-0127-01
MCF-1-977-00-0128-01
MCF-1-977-00-0129-01
MCF-1-977-00-0130-01
MCF-1-977-00-0131-01
MCF-1-977-00-0132-01
MCF-1-977-00-0133-01
MCF-1-977-00-0134-01
MCF-1-977-00-0135-01
MCF-1-977-00-0136-01
MCF-1-977-00-0137-01
MCF-1-977-00-0138-01
MCF-1-977-00-0139-01
MCF-1-977-00-0140-01
MCF-1-977-00-0141-01
MCF-1-977-00-0142-01
MCF-1-977-00-0143-01
MCF-1-977-00-0144-01
MCF-1-977-00-0145-01
MCF-1-977-00-0146-01
MCF-1-977-00-0147-01
MCF-1-977-00-0148-01
MCF-1-977-00-0149-01
MCF-1-977-00-0150-01
MCF-1-977-00-0151-01
MCF-1-977-00-0152-01
MCF-1-977-00-0153-01
MCF-1-977-00-0154-01
MCF-1-977-00-0155-01
etc.
Bookmarks