I work for a charity and not too familiar with excel.
The data is is imported from our website into a spreadsheet but the orders are not separated into rows and columns as I would like. Is it possible to arrange multiple data in rows into one column? Not every row has the same number of entries.I have used text to columns to convert csv data into columns.
This is how the import appears on the csv file:
Orders Product Name 50, 30 water aid, food parcel 5 general 20 medical 1, 5, 20, 100 general, water aid, medical, food
AND This is what I would like it to look like.
Orders Product name 50 water aid 30 food parcel 5 general 20 medical 1 general 5 water aid 20 medical 100 food
Really not sure how i can import the csv format here, anyone help?