mavsfan360
New Member
- Joined
- May 17, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all, I am working on something and I need a bit of help.
Basically I have a table that contains entries filled out by a user. In this table, I have 30 columns that are for Usernames, each column is for a specific company. When the user inputs the username, they only complete one per row. I end up with 1 cell that has information and 29 blanks. I need to be able to either find the cell with the username and populate that in another cell or delete all of the blanks in that row. I basically need the username (in example COKE123) to be input into the "Username" column
The table looks something like this:
Company Analyst Date Reviewed Username PaylessU PetsmartU TargetU CocaColaU BigLotsU PepsiU NestleU
Coke David 5.1.2022 Yes COKE123
Basically I have a table that contains entries filled out by a user. In this table, I have 30 columns that are for Usernames, each column is for a specific company. When the user inputs the username, they only complete one per row. I end up with 1 cell that has information and 29 blanks. I need to be able to either find the cell with the username and populate that in another cell or delete all of the blanks in that row. I basically need the username (in example COKE123) to be input into the "Username" column
The table looks something like this:
Company Analyst Date Reviewed Username PaylessU PetsmartU TargetU CocaColaU BigLotsU PepsiU NestleU
Coke David 5.1.2022 Yes COKE123