hoopsta1423
New Member
- Joined
- Nov 30, 2020
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Hi Folks,
I've got a spreadsheet of codes and descriptions. Some descriptions only fall on one row, others are longer and fall into multiple rows (sometimes up to 60+ rows). I'm trying to figure out a way to easily append the text from those code descriptions over multiple rows into the top line for that code
Example:
Any help here would be greatly appreciated because I've got 18000 rows * 15 separate sheets that need to be completed the same way
Thanks in advance!
I've got a spreadsheet of codes and descriptions. Some descriptions only fall on one row, others are longer and fall into multiple rows (sometimes up to 60+ rows). I'm trying to figure out a way to easily append the text from those code descriptions over multiple rows into the top line for that code
Example:
CODE | LINE NUMBER | DESCRIPTION |
265 | 1 | This description continues for |
265 | 2 | multiple lines and I need |
265 | 3 | to combine them into a single |
265 | 4 | row, some descriptions continue for 60+ lines |
365 | 1 | This line also continues below |
365 | 2 | but stops at two lines |
765 | 1 | This description thankfully only takes up one row |
Any help here would be greatly appreciated because I've got 18000 rows * 15 separate sheets that need to be completed the same way
Thanks in advance!