richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 87
- Office Version
- 2016
- Platform
- Windows
I have a bunch of account numbers with a bunch of different categories/Account Types under the same account number.
Categories can range from 01 to 06. I need to put all of the Account Types with the name on one row with the Account Number
My report looks something like this.
Not every account will have all of the account types. Some will have just one and some will have six.
Is this doable?
Thank you!
Would look something like this.
Categories can range from 01 to 06. I need to put all of the Account Types with the name on one row with the Account Number
My report looks something like this.
Not every account will have all of the account types. Some will have just one and some will have six.
Is this doable?
Thank you!
| Account Number | Account Type | Name | Other | Other 2 |
| 123456899 | 01 | Bob Smith | A | B |
| 123456899 | 02 | Mary Smith | G | H |
| 123456899 | 03 | Jane Smith | K | F |
| 123456899 | 04 | Kyle Smith | E | F |
| 123456899 | 05 | Tom Smith | F | F |
| 123456899 | 06 | Linda Smith | U | D |
| 23456855 | 01 | Larry Jones | Y | D |
| 23456855 | 02 | Paul Jones | H | D |
| Account Number | Account Type | Name | Other | Other 2 | Account Type | Name | Other | Other 2 | Account Type | Name | Other | Other 2 | Account Type | Name | Other | Other 2 | Account Type | Name | Other | Other 2 | Account Type | Name | Other | Other 2 |
| 123456899 | 01 | Bob Smith | A | B | 02 | Mary Smith | G | H | 03 | Jane Smith | K | F | 04 | Kyle Smith | E | F | 05 | Tom Smith | F | F | 06 | Linda Smith | U | D |
| 23456855 | 01 | Larry Jones | Y | D | 02 | Paul Jones | H | D |
Last edited:
