Thread: [Solved] Cleaning up a database
View Single Post
 
Old 08-09-2017, 07:37 AM
doctormathis doctormathis is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 5
doctormathis is on a distinguished road
Default Example

Here is the example.

I have labeled the tabs "Start Point" and "Example of end Product"

As you can see from the Notes column on the Start Point tab we have three instances. This is known by the initials MSF. MSF is the user ID that inputted the data originally. The initials are then followed by a date and then terminates with the note section.

The question is how do I splice the initials, date, and notes from the original "Notes" Column into their own column and row. Each instance needs its own row.
Attached Files
File Type: xlsx example.xlsx (11.3 KB, 9 views)
Reply With Quote