| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need help with Converting Rows of data into 2 columns
I have a spreadsheet that has several rows of data varying in length.
Everything under the first column is a part number then everything to the right of the part number in each row is a product code. I need something that will convert this: PN PROD PROD PROD PROD PROD PROD PROD 12345 rq545 gr433 or444 tz222 hq444 pl111 67892 ca544 ca899 cb355 ay111 98765 dd777 hw345 pp943 qa612 tw555 uj764 vf544 58992 gh678 lo122 uo512 mm677 xx411 INTO: PN PROD 12345 rq545 12345 gr433 12345 or444 12345 tz222 12345 hq444 12345 pl111 67892 ca544 67892 ca899 67892 cb355 67892 ay111 98765 dd777 98765 hw345 98765 pp943 98765 qa612 98765 tw555 98765 uj764 98765 vf544 58992 gh678 58992 lo122 58992 uo512 58992 mm677 58992 xx411 except on a much larger scale of data.... any help would be appreciated.....Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
| Control pasted/imported data to use only ODD or EVEN rows | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
