I feel like this should be an easy one. I have a spreadsheet that has text in the first cell of each row. Random columns in that row have the letter "X" when that text is reference. I would like to replace the 'X' with the text in the first cell of that row. Then have the code look though the spreadsheet and do that same for each row.
|Blah Blah Blah||X|
|Do Re Me||X||X|
|Tic Tac Toe||X||X|
|Blah Blah Blah||Blah Blah Blah|
|Do Re Me||Do Re Me||Do Re Me|
|Tic Tac Toe||Tic Tac Toe||Tic Tac Toe|