I am having a very hard time trying to extract data from a Tabula export that stacks my data in one column. I have seen several methods using a modulo column, but they all require the data to be stacked in a pattern. My data is stacked like this:
Where the prices correspond the product above them. I want to get a table with an Invoice, SKU and a Price column. Product 55555 has a price of 2.25 and product 66669 has a price of 1.25, etc Please let me know if you have a trick for this!