Hi,
I don't know how to describe this so I created an example below. My data is run from an accounting report and isn't very clean. The company name is listed and then the data below that company name are sales related to that company until the next company name. I would like to create a column for company name within the data so I can eliminate those rows and have a nice clean data table. In this example c123 and b832 should have "company 1" listed in the new column, company, and d822 should have "company 2" listed. I'm not sure how to write this formula as there is a varying quantity of data under each company. I would appreciate any help. Thanks!
ID | REF | Date | Amount |
Name: | Company 1 | ||
c123 | c123 | 1/1/2020 | 100 |
b832 | b832 | 2/4/2020 | 350 |
Name | Company 2 | ||
d822 | d822 | 3/16/2020 | 500 |
Name | Company 3 | ||
l986 | l986 | 6/1/2020 | 210 |
v687 | v687 | 4/13/2020 | 10 |
Solved! Go to Solution.
Thank you that worked perfectly!
Glad to help! Please mark whoever's you used as the solution when you have a chance. Have a great weekend!
Thanks,
Seth