Hi Good Day All. My objective is to automatically generate a list of subject codes. The inputs are the Subject, Level and Number.
Example If I entered Maths,2,4 respectively, I would want an automatically generated output that says Maths2-1, Maths2-2,Maths2-3, Maths2-4. Please see worksheet attached for better clarification.
I am not sure if this can be solved with a formula or would vba be better. Any help will be greatly appreciated.
You could do it using formula. But I'd recommend using PowerQuery (Get & Transform).
Select A1:C4 and Data ribbon -> From Table/Range.
Once in the editor. Add custom column.
Then use button at top right of the custom column to expand to rows.
Please Login or Register to view this content.
Select Level & custom column. Right click merge, Separator -> Custom and use dash '-'.
Select Subject & merged column and merge, without separator. Right click on Number and remove column.
Rename merged column as Subject Code.
Return result to desired location in sheet.
As you add more to the original list, you can just refresh the table to update with more Subject Code.
See attached.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
It works. Thank you very much.
I just need to spend some time understanding this feature because it might be able to help a lot in the future.
Thanks once again
You are welcome
If you are satisfied with the solution, please mark the thread as solved using thread tools found at top of your initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks