Populating Cell based on Array within same row

[mavsfan360]

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

 

[mavsfan360]

Date

Reviewer

Entry Reviewed

Username

Password

Company

Coke Username

Target Username

Pepsi Username

Hershey Username

Taco Bell Username

Krispy Kreme Username

Pizza Hut Username

5.1.2022

Bill

yes

12345​

Taco Bell

TacoBell12345

 

[mavsfan360]

Date

Reviewer

Entry Reviewed

Username

Password

Company

Coke Username

Target Username

Pepsi Username

Hershey Username

Taco Bell Username

Krispy Kreme Username

Pizza Hut Username

5.1.2022

Bill

yes

12345​

Taco Bell

TacoBell12345

In the original post the example table is incorrect. What I really need is to find the Taco Bell Username and have it input into the "Username" field in between "Entry Reviewed" and "Password"