Hello All! Let's say I have a spreadsheet that has 10 rows for a company (column A) and contains rows for 100 companies. In column B, there may be a fiscal year value but only in one row for a company. I want to update column B with that fiscal year value for all the rows for that company.
Simple example (all ABC Co. col B will be set to 2020 and all GHI Co. col B will be set to 2021):
A B
Row 1 ABC Co.
Row 2 ABC Co. 2020
Row 3 DEF Co.
Row 4 DEF Co.
Row 5 GHI Co. 2021
Row 6 GHI Co.
Simple example (all ABC Co. col B will be set to 2020 and all GHI Co. col B will be set to 2021):
A B
Row 1 ABC Co.
Row 2 ABC Co. 2020
Row 3 DEF Co.
Row 4 DEF Co.
Row 5 GHI Co. 2021
Row 6 GHI Co.
