I need help on LibreOffice Calc.
Im rewriting from a pdf catalog a tons of goods into xls file.
Id like to know if theres a way to actually load names,pages,prices,manufacturers into list, then let that list fill the columns and pair it up with each other? Wiritng it manually is gonna kill a lot of time. Is there a way to speed it up this way?
An helpfull fellow on IRC described it this way : what;s relevant is “column A has this sample data: …; column B has this: …; I need this in C - following these rules…”)
EDIT: Lets say i need Column A to have differents types of item numbers within some sort of categorazation(ex numbers like 110 210). Next Column C lets say its designed to have names of products which id like to somehow extract or add into list > then iwould spawn these names into this column. Then i could pair/manually spawn these numbers with products.
All the goods have some variants(colour,price,differences) but name and item no need to be paired , then there are colours and manufacturers which i need to pair up with.